Degree Seeker Week at SQL University, Lesson 2
Degree Seeker Week at SQL University, Lesson 2
Welcome once again eager learners to Lesson 2 of Degree Seeker Week at...
2010-07-08
2,224 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Degree Seeker Week at SQL University, Lesson 3
Degree Seeker Week at SQL University, Lesson 3
Welcome back eager learners to Degree Seeker Week at SQL University. I’m your...
2010-07-08
2,712 reads
Degree Seeker Week at SQL University, Lesson 1
Degree Seeker Week at SQL University, Lesson 1
Welcome eager learners to Lesson 1 of Degree Seeker Week at SQL University....
2010-07-05
2,626 reads
T-SQL Tuesday #008: Gettin’ Schooled
T-SQL Tuesday #008: Gettin’ Schooled
“Thank you fans and friends & odds and ends. And now for you gals and guys, a...
2010-07-04
9,227 reads
Extracurricular Activities
Extracurricular Activities
Recently I presented two sessions at SQL Saturday #43 in Redmond, WA. The night prior to the event, many...
2010-07-03
697 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,131 reads
Error 25602 When Creating an Extended Events Session: a Security Risk
Error 25602 When Creating an Extended Events Session: a Security Risk
I came across an interesting issue recently when helping someone...
2010-06-23
3,545 reads
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,937 reads
Building HTML Emails With SQL Server and XML
Building HTML Emails With SQL Server and XML
I’ve written a lot of custom reports in my days that output data...
2010-06-15
62,551 reads
SQL Saturday #43 in the Books
SQL Saturday #43 in the Books
Another great SQL Saturday is in the books!! I had submitted 2 sessions, but there...
2010-06-12
901 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
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
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
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