SQL RNNR

Blog Post

The Gift of the SPN

Every once in a while there is an extremely valuable tool that comes along. While the footprint and use frequency of this tool may not be that big, the...

2019-12-20 (first published: )

707 reads

Blog Post

The Gift of the SPN

Every once in a while there is an extremely valuable tool that comes along. While the footprint and use frequency of this tool may not be that big, the...

2019-12-10

6 reads

Blog Post

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

2019-08-09 (first published: )

262 reads

Blog Post

Finding Data Gaps

Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...

2019-08-05 (first published: )

517 reads

Blog Post

Finding Data Gaps

Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...

2019-07-11

4 reads

Blog Post

Event Files on Linux

For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...

2019-07-29 (first published: )

191 reads

Blog Post

Event Files on Linux

For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...

2019-07-10

6 reads

Blogs

A New Word: Ecstatic Shock

By

ecstatic shock – n. a surge of energy upon catching a glimpse from someone...

The CDO’s Playbook for AI Driven Decision Making

By

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

By

Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...

Read the latest Blogs

Forums

Recursive Select - What is this really doing

By Leo.Miller

I've noticed several instances of what looks like a recursive insert with the format:...

Cleaning Up the Cloud

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Up the Cloud

The Maximum Value in the Identity Column

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Maximum Value in the...

Visit the forum

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-06
I 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