[T-SQL] Modifica SP

[geko]

...oppure

ALTER PROCEDURE [dbo].[SP_LOGIN]
(
 @USERID Varchar(20),
 @PASSWORD Varchar(6), 
 @id INT OUTPUT
)
AS

SELECT @id = id 
FROM TBLOCALI 
WHERE userid = @USERID 
AND pwd = @PASSWORD

IF @id IS NULL SET @id = -1