Browse by Tags

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....
Table Variables and OUTPUT clause
14 June 09 06:14 PM | MartinBell | 6 comment(s)
At the end of my previous post on the OUTPUT clause I mentioned the fact that the OUTPUT clause can be very useful if you want to see the effects of an INSERT/UPDATE/DELETE or MERGE statement without actually committing the change by rolling back the...
Filed under: ,
Are you making the most of the OUTPUT clause?
09 June 09 05:20 PM | MartinBell | 2 comment(s)
In my previous posts I have looked at using the OUTPUT clause to return GUID values generated by the database and how you can return these to an ADO.Net application but this doesn't really give an indication of the power and usefulness that clause can have.......
Filed under: ,
Returning GUID values to ADO.NET clients
09 June 09 08:44 AM | MartinBell | 3 comment(s)
My previous post showed how to return a database generated GUID as a stored procedure parameter, but if more than one GUID is generated what do you do?...
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?...

This Blog

SQL Blogs