Generate a GUID in MS SQL (t/SQL)

Hello,
I'm writing a MS SQL script to roll-up an Event List in Sharepoint, and
I have it working except I haven't found a way to generate a GUID using
t/SQL in MS SQL. Is there a function or script or something I can use
to generate a GUID value? I can do this in ASP or ColdFusion or a few
other ways, but keeping this totally in MS SQL as a stored procedure I
can schedule to run periodically would be the simplest.
Thanks for any suggestions or ideas on this.
Also, from a Sharepoint standpoint, SPS nor WSS supports roll-ups for
Events or any list, which is why I'm writing this on my own. Also
there are third party plugins, but most are around $1600 or more, which
is crazy since this can be done in MS SQL if I can only figure out the
GUID bit.
Thanks for any help or assistance --
SamSam
Try newid(), I don't have access to the query analyzer tonight, but
from memory it should a litlte like:
<sql snippet>
DECLARE @.MyUUID AS uniqueidentifier
SET @.MyUUID = newid()
SELECT @.MyUUID
</sql:snippet>
HTH,
Duncan.|||Have you tried this method?
SELECT NEWID()
Keith Kratochvil
"Alex" <samalex@.gmail.com> wrote in message
news:1141685000.839522.40640@.i39g2000cwa.googlegroups.com...
> Hello,
> I'm writing a MS SQL script to roll-up an Event List in Sharepoint, and
> I have it working except I haven't found a way to generate a GUID using
> t/SQL in MS SQL. Is there a function or script or something I can use
> to generate a GUID value? I can do this in ASP or ColdFusion or a few
> other ways, but keeping this totally in MS SQL as a stored procedure I
> can schedule to run periodically would be the simplest.
> Thanks for any suggestions or ideas on this.
> Also, from a Sharepoint standpoint, SPS nor WSS supports roll-ups for
> Events or any list, which is why I'm writing this on my own. Also
> there are third party plugins, but most are around $1600 or more, which
> is crazy since this can be done in MS SQL if I can only figure out the
> GUID bit.
> Thanks for any help or assistance --
> Sam
>