Declare @TempBiaoTi char(60) select @TempBiaoTi = BiaoTi from WenZhangTable Where BiaoTi=@BiaoTi or:Declare @TempBiaoTi char(60) set @TempBiaoTi = (select BiaoTi from WenZhangTable Where BiaoTi=@BiaoTi)哈,哈哈,哈哈哈......
调试欢乐多
or
Declare @TempBiaoTi char(60) Select @TempBiaoTi = BiaoTi from WenZhangTable Where BiaoTi=@BiaoTi
不过这样做有个条件,你的SELECT只能返回一条记录,否则就会出错。
Declare @TempBiaoTi char(60) Select @TempBiaoTi=BiaoTi from WenZhangTable Where BiaoTi=@BiaoTi
Declare @a char(60),@b char(60),@c char(60)Select @a=BiaoTi,@b=BiaoTi,@c=BiaoTi from WenZhangTable Where BiaoTi=@BiaoTi