3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
开贴提几个小问题，提够了一起给分
1.有个sql:select VAR from T1 where ID=1
假如上面sql反回一个记录，我想把VAR字段赋给变量@VAR怎么写？
假如上面sql反回一个记录，我想把VAR字段赋给变量@VAR怎么写？
...全文
请发表友善的回复…
发表回复
sdhdy 2003-12-19
--这种方法不行，如果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)
declare @var varchar(255)
set @var=(select var from t1 where id=1 order by var)
yuncai 2003-12-19
不好意思写错了一个
正确的应该是
declare @var varchar(255)
set @var=(select top 1 var from t1 where id=1 order by var)
正确的应该是
declare @var varchar(255)
set @var=(select top 1 var from t1 where id=1 order by var)
yuncai 2003-12-19
declare @var varchar(255)
set @var=(select var from t1 where id=1 order by var)
set @var=(select var from t1 where id=1 order by var)
jiangchuandong 2003-12-19
declare @var varchar(200)
select @var=VAR from t1 where id=1
select @var=VAR from t1 where id=1
dlpseeyou 2003-12-19
declare @var varchar(100)
set @var=(select var from t1 where id=1)
set @var=(select var from t1 where id=1)
sdhdy 2003-12-19
declare @VAR varchar(100)
select @VAR=VAR from T1 where ID=1
select @VAR=VAR from T1 where ID=1
txlicenhe 2003-12-19
select top 1 @var=VAR from t1 where id=1
shuiniu 2003-12-19
假如上面sql反回不止一个记录!
那@var的值是结果集的最后一个值!
那@var的值是结果集的最后一个值!
shuiniu 2003-12-19
declare @var varchar(200)
select @var=VAR from t1 where id=1
select @var=VAR from t1 where id=1
victorycyz 2003-12-19
select @var=VAR from t1 where id=1
lynx1111 2003-12-19
declare @var varchar(200)
set @var=(select var from t1 where id=1)
set @var=(select var from t1 where id=1)
blueonly 2003-12-19
暂时只用到返回一个的情况，所以算是解决了