http://snipplr.com/users/emregulcan/tags/trigger Recent snippets posted on Snipplr.com en-us Sun, 19 May 2013 16:51:22 GMT http://snipplr.com/view/48656/sql-inserted-trigger/ 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 ;)

]]> Wed, 09 Feb 2011 14:09:14 GMT http://snipplr.com/view/48656/sql-inserted-trigger/