Create PROCEDURE sp_mUserCheck
@tempmy int,
@tempuid int,
@uid int out,
@userid int out
Select Top 1 @uid=uid,@userid=userId From Users Where uId=@tempuid
GO
--调用
declare @uid int,@userid int
exec sp_mUserCheck 1,1,@uid out,@userid out
select @uid,@userid
@tempmy int,
@tempuid int,
@uid int out,
@userid int out
Select Top 1 @uid=uid,@userid=userId From Users Where uId=@tempuid
GO
--调用
declare @uid int,@userid int
exec sp_mUserCheck 1,1,@uid out,@userid out
select @uid,@userid
@A int output
as
select @a=a from tablename where ...
go
declare @a int
exec test @A=0 ouput
select @a