Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Returning the value of the unique ID?

rlcrlc Member Posts: 448
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.

~rlc

Comments

  • DaedaliusDaedalius Member Posts: 30
    @IDENTITY in the BOL.

    : 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.
    :
    : ~rlc
    :

Sign In or Register to comment.