CREATE TABLE myTable ( id int IDENTITY(1,1), a int NULL, b int NULL)
CREATE PROCEDURE AddmyTable @newID int OUTPUT, @a int, @b int AS INSERT INTO myTable (a, b) VALUES (@a, @b) IF @@ERROR <> 0 BEGIN RETURN -1 END SET @newID = SCOPE_IDENTITY() RETURN 0