create procedure sp_AddUser1
@Name nvarchar(200),
@Remark nvarchar(200),
@Flag int
as
begin
declare @id int
insert into User(Name,Remark,Flag) values(@Name, @Remark,@Flag)
set @id = scope_identity()
update User set Sort=@id where ID=@id
end
create procedure sp_AddUser2
@Name nvarchar(200),
@Remark nvarchar(200),
@Flag int,
@id int output
as
begin
insert into User(Name,Remark,Flag) values(@Name, @Remark,@Flag)
set @id = scope_identity()
end