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子句
@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子句
@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
......
@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