34,593
社区成员
发帖
与我相关
我的任务
分享如何将select出来的结果赋值给变量@sum_all？
大概如下：
declare @sum_all as int
select sum(1) [into @sum_all]
from tbl
group by col1
declare @sum_all as int
select sum(1) [into @sum_all]
from tbl
group by col1
...全文
请发表友善的回复…
发表回复
mymmsc 2003-02-27
- 打赏
- 举报
标记
pengdali 2003-02-19
- 打赏
- 举报
declare @firstName as varchar(100)
select top 1 @firstName = col1
from tbl
select top 1 @firstName = col1
from tbl
pengdali 2003-02-19
- 打赏
- 举报
那你就:
declare @ varchar(8000)
set @=''
select @=@+字符列 from 表
declare @ varchar(8000)
set @=''
select @=@+字符列 from 表
battlet 2003-02-19
- 打赏
- 举报
哦，对了，
如下
declare @firstName as varchar(100)
select @firstName = first(col1)
from tbl
如何实现？
如下
declare @firstName as varchar(100)
select @firstName = first(col1)
from tbl
如何实现？
zengpan_panpan 2003-02-19
- 打赏
- 举报
如果是个多行结果就麻烦了。
pengdali 2003-02-19
- 打赏
- 举报
declare @sum_all as int
select @sum_all=sum(1)
from tbl
group by col1
select @sum_all=sum(1)
from tbl
group by col1
