codice:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



ALTER PROCEDURE [dbo].[SP_LOGIN]
(
 @USERID Varchar(20),
 @PASSWORD Varchar(6)
)
AS
IF EXISTS
(
  SELECT * FROM TBLOCALI WHERE userid = @USERID AND pwd = @PASSWORD
)
 RETURN 0
ELSE
 RETURN 1
come faccio a modificare questa per farmi tornare l'ID (Primary Key) ?