When you enter a new record into a table that contains an identity column, the identity value will be set with the next available value. Your database design often requires you to obtain that value, so you need to be able to find it.
2011-05-05
5,354 reads
2010-10-06
3,263 reads
2010-09-29
3,142 reads
2010-06-28
3,485 reads
2010-05-31
3,575 reads
2010-04-20
4,596 reads
2010-03-17 (first published: 2010-03-04)
1,525 reads
This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.
2010-03-03
2,989 reads
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
2010-01-20
4,569 reads
2010-01-04
4,204 reads
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Comments posted to this topic are about the item The Improvement Limit
Comments posted to this topic are about the item Migrate SSRS Reports to a...