SQL Inserted Trigger

/ Published in: SQL
Save to your folder(s)

This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier)

If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity .

So, I write a trigger on my table to get last record guid info ;)

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.