CREATE PROCEDURE spSaveUtilizatori
@ID AS INT OUTPUT,
@Login AS VARCHAR (12),
@Password AS NVARCHAR (20),
@Email AS VARCHAR (50)
AS
SET NOCOUNT ON
SET ANSI_WARNINGS OFF
DECLARE @err INT
IF @ID IS NULL
BEGIN
INSERT INTO Utilizatori
VALUES (@Login,
@Password,
@Email
)
SET @err = @@ERROR
SET @ID = @@IDENTITY
END
ELSE
BEGIN
UPDATE Utilizatori
SET Login = @Login,
Password = @Password,
Email = @Email
WHERE [ID] = @ID
SET @err = @@ERROR
END