Making a Career Change of My Own
Making a Career Change of My Own
I commented about a month ago on the high profile career changes that seemed...
2010-07-30
2,479 reads
Making a Career Change of My Own
I commented about a month ago on the high profile career changes that seemed...
2010-07-30
2,479 reads
Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)
My presentation scheduled for earlier this week to...
2010-07-30
1,646 reads
Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter
I will be presentitng to the West Michigan SQL...
2010-07-26
828 reads
T-SQL Tuesday #008: Gettin' Schooled
Welcome to another exciting episode of T-SQL Tuesday. I’m Robert L Davis (blog|@SQLSoldier), and I’m...
2010-07-18
2,406 reads
Advanced Troubleshooting Week at SQL University, Lesson 2
Welcome back to Advanced Troubleshooting Week at SQL University. I’m your guest professor...
2010-07-16
1,982 reads
Advanced Troubleshooting Week at SQL University, Lesson 3
Welcome back to Advanced Troubleshooting Week at SQL University. I’m your guest professor...
2010-07-16
1,847 reads
Advanced Troubleshooting Week at SQL University, Lesson 1
Welcome to Advanced Troubleshooting Week at SQL University. Once again, I’m your guest...
2010-07-13
5,396 reads
T-SQL Tuesday #008: Tips for Giving a Good Interview for the New DBA
Welcome to another exciting episode of T-SQL...
2010-07-13
1,175 reads
Degree Seeker Week at SQL University, Extra Credit
Welcome back to Degree Seeker Week at SQL University. If you have returned...
2010-07-12
1,739 reads
Come See Me at the SQL PASS Summit
Notifications went out today for the SQL PASS Summit (Nov. 8 - 11, 2010)...
2010-07-08
915 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
I've noticed several instances of what looks like a recursive insert with the format:...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
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 OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers