Friday, February 27, 2009

How to retrieve GUID inserted in a database table?

Using Stored Procedure Output parameter to return the GUID generated in the database.
(UniqueIdentifier has function NEWSEQUENTIALID() to generate a sequential GUID)
----------------
INSERT INTO myTable (columna) OUTPUT INSERTED.GUIDColumn VALUES(@columna)
----------------

INSERTED is a table created by Insert Trigger.



From:
http://blog.jemm.net/articles/databases/how-to-using-sql-server-2005s-output-to-return-generated-identity/

No comments:

Blog Archive