SysInternals now on Microsoft TechNet
It wasn't too long ago that Mark Russinovich announced he was becoming a Microsoft employee (new link as his old...
2006-11-27
1,682 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
NGSSoftware compares Oracle and SQL Server security
I first saw this at SQL Server MVP Jasper Smith's blog post Which database is more secure? Oracle vs. Microsoft:
NGSSoftware...
2006-11-25
1,699 reads
Teaching Children to Program
One of the blogs I follow is Andrew Coates' blog over at MSDN. He has posted about starting to help...
2006-11-21
1,452 reads
Mixed Feelings about the SQL Server Central Sale to Red Gate
I've read numerous posts and several blogs discussing the SQL Server Central sale to Red Gate and at the end...
2006-11-20
1,624 reads
SQL Server 2005 SP2 CTP Available for Download
The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download...
2006-11-08
1,972 reads
Chess
Recently I started getting back into the game of chess as I began coaching my boys. Chess is a great...
2006-11-02
1,680 reads
Picking back up on blogging
It has been a trying month to month and a half with the implementation of Microsoft's CRM 3.0 product. By...
2006-10-30
1,370 reads
Diversions
I've been rather quiet for a while and there's a reason. I've been
helping some friends get a general gaming site...
2006-09-22
1,502 reads
SQL Server 2005 Scripts on TechNet
I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...
2006-09-01
1,455 reads
Removing SQL Server Express from VS Team System for Database Professionals CTP 5
As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...
2006-08-24
1,381 reads
Blogs
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...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
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