开贴提几个小问题，提够了一起给分

[blueonly]

1.有个sql:select VAR from T1 where ID=1
假如上面sql反回一个记录，我想把VAR字段赋给变量@VAR怎么写？

[blueonly]

暂时只用到返回一个的情况，所以算是解决了

[lynx1111]

declare @var varchar(200)
set @var=(select var from t1 where id=1)

[victorycyz]

select @var=VAR from t1 where id=1

[shuiniu]

declare @var varchar(200)
select @var=VAR from t1 where id=1

[shuiniu]

假如上面sql反回不止一个记录!
那@var的值是结果集的最后一个值!

[txlicenhe]

select top 1 @var=VAR from t1 where id=1

[sdhdy]

declare @VAR varchar(100)
select @VAR=VAR from T1 where ID=1

[dlpseeyou]

declare @var varchar(100)
set @var=(select var from t1 where id=1)

[jiangchuandong]

declare @var varchar(200)
select @var=VAR from t1 where id=1

[yuncai]

declare @var varchar(255)
set @var=(select var from t1 where id=1 order by var)

[yuncai]

不好意思写错了一个
正确的应该是
declare @var varchar(255)
set @var=(select top 1 var from t1 where id=1 order by var)

[sdhdy]

--这种方法不行，如果select var from t1 where id=1 order by var返回多个记录的话，会出错的
declare @var varchar(255)
set @var=(select var from t1 where id=1 order by var)