Browse by Tags

TRIGGERS, IDENTITY, INSERTED and OUTPUT
03 May 11 08:55 PM | MartinBell | 1 comment(s)
Triggers can effect the value returned by @@INDENTITY and the common advice is to say that yoiu should always use SCOPE_IDENITITY, the post proces that that is not always good advice....
Wot no SCOPE_GUID() function??
08 June 09 03:23 PM | MartinBell | 4 comment(s)
When you have a database generated GUID value how do you find out what it is?...
IDENTITY a fraud?
12 May 09 06:58 PM | MartinBell | 1 comment(s)
One of the tips Tony gave during his talk at last weeks Manchester User Group was not to start your identity values at the default (zero) but start them at the lowest possible value for the datatype you are using. This is a great tip as it doubles the range of possible values and it happened to coincide with some thoughts I had for a connect suggestion....
Filed under:

This Blog

SQL Blogs

Syndication