可以在一条语句中给多个变量赋值。

[zl194]

数据库SQL2000 +SP4

我想在一个存储过程中，给自定义的多个变量赋值。
如：

create proc mypro
@uid varchar(10)
as
declare @c1 varchar(10)
declare @c2 varchar(10)
declare @c3 varchar(10)
set @c1=(SELECT top 1 cname from tb_user where uid=@uid)
set @c2=(SELECT TOP 1 age from tb_user where uid=@uid)
set @c3=(SELECT TOP 1 sex from tb_user where uid=@uid)

…………

go

[昵称被占用了]

create proc mypro
@uid varchar(10)
as
declare @c1 varchar(10)
declare @c2 varchar(10)
declare @c3 varchar(10)
SELECT top 1 @c1 = cname,@c2=age,@c3=sex from tb_user where uid=@uid
-- order by ...

…………

go

最好有order by子句

[水族杰纶]

create proc mypro
@uid varchar(10)
as
declare @c1 varchar(10)
declare @c2 varchar(10)
declare @c3 varchar(10)
SELECT top 1 @c1=cname from tb_user where uid=@uid
SELECT TOP 1 @c2=age from tb_user where uid=@uid
SELECT TOP 1 @c3=sex from tb_user where uid=@uid
......

[喜-喜]

create proc mypro
@uid varchar(10)
as
declare @c1 varchar(10)
declare @c2 varchar(10)
declare @c3 varchar(10)
SELECT top 1 @c1=cname,@c2=age,@c3=sex from tb_user where uid=@uid

…………

go

[zl194]

谢谢了。