Think Using .. In Code Is A Time Saver? Think Again!
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
485 reads
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
485 reads
You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you...
2016-09-22
403 reads
I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What...
2016-09-22
478 reads
A lot of these types of events are pulled together by the local user group. If there is none, it...
2016-08-31
724 reads
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...
2016-08-26
430 reads
This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s...
2016-07-12
517 reads
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great...
2016-06-29
691 reads
No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced,...
2016-06-24
415 reads
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you...
2016-04-28
798 reads
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
796 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
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