--创建存储过程带参数返回状态
if (exists (select * from sys.objects where name = 'proc_test'))
drop proc proc_test
go
create procedure proc_test
@LoginName varchar(50),
@LoginPwd varchar(50),
@Status int out
as
insert into DT_USER values(@LoginName,@LoginPwd)
set @status = @@IDENTITY
select *from DT_USER