Browse by Tags

Table Variables and OUTPUT clause
14 June 09 06:14 PM | MartinBell | 2 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: OUTPUT, Table Variables

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: OUTPUT, MERGE

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?...

Filed under: NEWSEQUENTIALID(), GUID, OUTPUT

Wot no SCOPE_GUID() function??
08 June 09 03:23 PM | MartinBell | 2 comment(s)

When you have a database generated GUID value how do you find out what it is?...

Filed under: Identity, NEWSEQUENTIALID(), GUID, NEWID(), OUTPUT