CODEWITHSUNDEEP
sql-server-2000uniqueidentifiernewid
Shay
Shay

Reputation: 1778

Get last inserted UNIQUEIDENTIFIER in SQL Server 2000

The OUTPUT clause is compatible with SQL Server 2005 but not SQL Server 2000.

How do I convert this command to work in SQL Server 2000?

CREATE TABLE sample
(
 ID uniqueidentifier NOT NULL DEFAULT newid(),
 Title varchar(30) NOT NULL
)

INSERT INTO sample (Title)
OUTPUT INSERTED.ID
VALUES ('Test1')

I need the command to retrieve the ID since the INSERT command needs to be called from a stored procedure.

Thanks for any help!

Upvotes: 9

Views: 12605

Answers (1)

Martin Smith
Martin Smith

Reputation: 453287

DECLARE @uid uniqueidentifier 
SET @uid  = newid()

INSERT INTO sample (ID, Title)
VALUES (@uid,'Test1')

SELECT @uid AS ID

Upvotes: 15

Related Questions