Newbie stored procedure question
I'm trying to create a stored procedure that will generate and return a unique identifier when called.
Here's my stored procedure code:
I'm getting the error: "Operand type clash: uniqueidentifier is incompatible with int"
After a few Google searches, I'm stuck as to how to fix this. Help!
Thanks.
Here's my stored procedure code:
CREATE PROCEDURE sp_tc_createuniqueid AS DECLARE @uid uniqueidentifier SET @uid = newid() RETURN @uid
I'm getting the error: "Operand type clash: uniqueidentifier is incompatible with int"
After a few Google searches, I'm stuck as to how to fix this. Help!
Thanks.
