Use Patterns and Prior Code and Don't Reinvent the Wheel
In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...
2011-02-21
1,972 reads
In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...
2011-02-21
1,972 reads
As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC. The event will be March 19, 2011...
2011-02-19
1,266 reads
At the end of March I'll be journeying down with the family to Orlando, Florida. We plan on stopping in...
2011-02-18
944 reads
There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...
2011-02-11
1,608 reads
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-11
2,330 reads
Thanks for hanging in there for Day 4 of Security Week here at SQL University. Today we're going to look at the...
2011-02-10
2,159 reads
Free training. Excellent speakers. Outstanding location. Great networking opportunities. Experienced and efficient event staff. These are the primary things you...
2011-02-10
2,143 reads
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-09
4,147 reads
Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll...
2011-02-08
2,464 reads
Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...
2011-02-08
1,933 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