Update on MSSQL::OlleDB - Name Change
SQL Server MVP Erland Sommarskog has announced
a name change to MSSQL::OlleDB. It's now known as Win32::SQLServer.
This is to bring it...
2005-11-27
1,340 reads
SQL Server MVP Erland Sommarskog has announced
a name change to MSSQL::OlleDB. It's now known as Win32::SQLServer.
This is to bring it...
2005-11-27
1,340 reads
Looked over at the Apex SQL site and noticed they released a new
version of ApexSQL Edit last weekend. I went...
2005-11-26
1,503 reads
In writing an article for SQL Server Standard's January issue, I received a tech edit comment from Adam Machanic
about a...
2005-11-25
1,486 reads
Visual Studio has spoiled me. I love the Intellisense feature that has continued to evolve with each new edition of Microsoft's...
2005-11-25
1,510 reads
Writing at article for SQL Server Central tends to be a very rewarding
experience. Every chance I get, I encourage others...
2005-11-25
1,486 reads
The following announcement came out this morning on the Annouce mailing list for MySQL:
"MySQL Connector/Net 1.0.7, a new version of...
2005-11-21
1,630 reads
David Litchfield has put out a brief (as
he says it, "It's called a brief because there's enough meat to make...
2005-11-19
1,399 reads
There has been some talk on Google Base on the Full Disclosure security
list. I've also seen on another blog about...
2005-11-19
1,391 reads
Catching back up on things. MySQL 5.0 went "RTM" at the end of October.
Haven't had a lot of chances to...
2005-11-19
1,364 reads
For those who use Perl and access SQL Server, MVP Erland Sommarskog has
announced a new module which uses OLE DB...
2005-11-19
1,520 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,...
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...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
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