Hi to all,
I'm using a stored proc to insert recs into table in SQL 2000. One column of the table is Uniqueidentifier and rowguide. When i insert, it creates a GUID value in that field.
Now I want to have this Guid available to insert it in a new line in another table.
I use @@identity in return value of my stored proc but it always returns '0', even if the Guid is correctly created...(
Any idea ?
TIA !-)
Yak
I'm using a stored proc to insert recs into table in SQL 2000. One column of the table is Uniqueidentifier and rowguide. When i insert, it creates a GUID value in that field.
Now I want to have this Guid available to insert it in a new line in another table.
I use @@identity in return value of my stored proc but it always returns '0', even if the Guid is correctly created...(
Any idea ?
TIA !-)
Yak