Posted By

emregulcan on 02/09/11

Tagged

Versions (?)

Last Edited at 02/09/11 02:09pm

Statistics

Viewed 760 times

Favorited by 1 user(s)

Related snippets

SQL Inserted Trigger

/ Published in: SQL

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 ;)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CREATE TRIGGER dbo.InsertTriggerOnGUIDYourtable
ON dbo.YourTable
FOR INSERT
AS
BEGIN
     SET NOCOUNT ON
 
     SELECT GUIDCol AS '@@GUID'
     FROM inserted
END

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.