Post reply

Getting UNIQUEIDENTIFIER data

  • July 17, 2003 at 2:11 am

    #80810

    Hi,

    I am using UNIQUEIDENTIFIER column for my table. I do not insert data for it. I left it on database by setting to default NEWID(). Now in my application I need the value of UNIQUEIDENTIFIER column I just inserted. Is there any function or query to get this value like in case of IDENTITY column we can get the latest inserted value from select @@IDENTITY.

    Thanks and regards,

    Uday

    Edited by - udayt on 07/17/2003 02:12:39 AM

  • July 17, 2003 at 3:18 am

    #465791

    Hi Uday,

    quote:

    I am using UNIQUEIDENTIFIER column for my table. I do not insert data for it. I left it on database by setting to default NEWID(). Now in my application I need the value of UNIQUEIDENTIFIER column I just inserted. Is there any function or query to get this value like in case of IDENTITY column we can get the latest inserted value from select @@IDENTITY.

    Cross post in different topics?

    Cheers,

    Frank

    Edited by - a5xo3z1 on 07/17/2003 03:17:52 AM

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 17, 2003 at 4:43 am

    #465796

    See related comments in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14278&FORUM_ID=8&CAT_ID=1&Topic_Title=Getting+UNIQUEIDENTIFIER+data&Forum_Title=T%2DSQL

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply