Hello,
I am very new to creating transact-SQL, and I am stuck, so I was hoping someone could help me out.
I created this command (piecing together things online), and I want to output a GUID, but it seems that it wants me to input a GUID when I call the function. How can I make it output, without having to input the GUID part
ALTER
PROCEDURE [dbo].[HandleKeyWord]@KEYWORD
VARCHAR (100),@MYGUID
UNIQUEIDENTIFIER OUTPUTAS
IF
(SELECT COUNT(*) FROM KEYWORDS WHERE KEYWORD=@KEYWORD) > 0 BEGIN SELECT @MYGUID = [ID] FROM KEYWORDS WHERE KEYWORD=@KEYWORD ENDELSE
BEGIN SET @MYGUID = CAST(CAST(NEWID() AS BINARY(10))+ CAST(GETDATE() AS BINARY(6)) AS UNIQUEIDENTIFIER) INSERT INTO KEYWORDS ([ID], [KEYWORD]) VALUES (@MYGUID, @KEYWORD) END
Thank you for your help.