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/
Subscribe to:
Post Comments (Atom)
Blog Archive
- June (1)
- April (2)
- April (1)
- August (1)
- April (1)
- March (1)
- February (1)
- March (1)
- February (2)
- August (1)
- April (1)
- March (1)
- February (2)
- November (3)
- September (1)
- August (1)
- June (1)
- April (1)
- March (1)
- February (5)
- January (1)
- August (1)
- July (1)
- January (2)
- August (1)
- June (1)
- March (4)
- February (3)
- January (3)
No comments:
Post a Comment