SA Developer .NET

...and I don't mean SCOPE_IDENTITY()

How can I get the value of the last UNIQUEIDENTIFIER inserted into a table with a DEFAULT value of NewSequentialID. I was hoping to find a built in function of sorts to give me the value as opposed to SELECTing it of the table itself.

---

A Program is only Complete when the Programmer Dies

No built-in function for that. You can use the OUTPUT clause though.

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!

How do you use the OUTPUT clause when inserting into a table.

---

A Program is only Complete when the Programmer Dies

2005 or 2008?

2005, output into a table variable and insert from there into the table (messy, but...)
2008, you can (I hear) insert directly from the output of one into another table. (note to self, need to figure it out and blog)

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!

Thanks Gila.

Our production environments are 2005.

 

---

A Program is only Complete when the Programmer Dies