@id uniqueidentifier OUTPUT
DECLARE @idTbl TABLE (id UNIQUEIDENTIFIER);

INSERT INTO product(name,...,etc)
OUTPUT INSERTED.id INTO @idTbl
OUTPUT INSERTED.id, INSERTED.mycolumn
VALUES ('myname',...,etcvalue)

SELECT TOP (1) @id = id FROM @idTbl;

quote:

---

Originally posted by James K

@id uniqueidentifier OUTPUT
DECLARE @idTbl TABLE (id UNIQUEIDENTIFIER);

INSERT INTO product(name,...,etc)
OUTPUT INSERTED.id INTO @idTbl
OUTPUT INSERTED.id, INSERTED.mycolumn
VALUES ('myname',...,etcvalue)

SELECT TOP (1) @id = id FROM @idTbl;

Of course, if you have more to the values clause (i.e., you are inserting more than one row via the insert statement), you will get only one of the values in the @id variable.

---

quote:

---

Originally posted by James K

@id uniqueidentifier OUTPUT
DECLARE @idTbl TABLE (id UNIQUEIDENTIFIER);

INSERT INTO product(name,...,etc)
OUTPUT INSERTED.id INTO @idTbl
OUTPUT INSERTED.id, INSERTED.mycolumn
VALUES ('myname',...,etcvalue)

SELECT TOP (1) @id = id FROM @idTbl;

Of course, if you have more to the values clause (i.e., you are inserting more than one row via the insert statement), you will get only one of the values in the @id variable.

---