Adding value to our organizations
Sean McCown writes in the latest Database Underground about how DBAs should try and make things better for users of...
2007-01-09
1,535 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Most humorous line I've read in a while
This is from Michael Kaplan's blog over at MDSN. He was writing about the power outage that affected the Northwest...
2007-01-07
1,357 reads
Shared Items on Google Reader
I read through a lot of blogs each day in a variety of technology categories. I've always fashioned myself as...
2007-01-06
1,354 reads
Midlands PASS January 2007 Meeting Minutes
January 4,
2007 Meeting Minutes: Members in
Attendance: 15Next Meeting
Date: February 1, 2007 Job
Board: I had a consulting
firm contact me...
2007-01-05
1,695 reads
Midlands PASS Chapter Meeting for January
Our next meeting will be
on Thursday, January 4, 2007, at 6:30 PM. It'll be at the Training Concepts
facility...
2006-12-29
1,495 reads
Setting Goals for the New Year and Beyond
I've never been a big fan of "New Year's Resolutions" for the same reason most other folks are against them:...
2006-12-29
1,591 reads
How to handle an invalid default database
My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...
2006-12-11
1,889 reads
Midlands PASS Chapter is official
A group of us met on Thursday, December 7th, 2006, and voted to approve the bylaws and a motion to...
2006-12-11
1,446 reads
Jason Haley recently began posting his interesting finds again
Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds...
2006-12-09
1,368 reads
SysInternals Tools Updated
Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass...
2006-12-09
1,426 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
The Maximum Value in the Identity Column
Comments posted to this topic are about the item The Maximum Value in the...
Question of the Day
The Maximum Value in the Identity Column
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')
I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON
INSERT dbo.TravelLog
(
TravelLogID,
CityID,
StartDate,
EndDate
)
VALUES
(25, 5, '2025-09-12', '2025-09-17')
SET IDENTITY_INSERT dbo.TravelLog OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers