sqlserver 存储过程

ALTER procedure [dbo].[SelectMyTable]
@id int,
@name varchar(44),
@pwd varchar(44)
--@id int
as        --定义结束

begin
    declare @ErrorID int
        set @ErrorID = 1000
    begin try
        Begin Tran TestTran --回滚的东西
        --insert into MyTestTable (name, pwd) values(@name, @pwd)
        --select * from MyTestTable where @id = ID
        update MyTestTable set name = @name, pwd = @pwd where id = @id
        Commit Tran TestTran
    end try
    begin catch
        set @ErrorID = 1001--//测试用的
    end catch

    If @@TRANCOUNT > 0 
    Begin
        Set @ErrorID = 1002
        RollBack Tran TestTran
    End

    return @ErrorID
end    

 

 

执行存储过程

exec SelectMyTable 3,999,444