I am using SQL Server 2000 and I am not very acustom to it yet.
I have a relational database using unique identifiers that SQL assigns through the Identity field. When I run an Insert I would like SQL to return the value of the UID it created (without me having to run a seperate query to get the value). I am sure there is way to do this, well pretty sure, since it can be done in mySQL and I would imagine it would be common for any relational DB...
Anyway, any help would be appreciated.