34,590
社区成员
发帖
与我相关
我的任务
分享赋值语句可以这么写吗？
DECLARE @sumdTotal decimal(18, 2)
SET @sumdTotal = 0.0
SET @sumdTotal= SELECT SUM(dMoney) AS dTemp FROM tblName
PRINT @sumdTotal
SET @sumdTotal = 0.0
SET @sumdTotal= SELECT SUM(dMoney) AS dTemp FROM tblName
PRINT @sumdTotal
...全文
请发表友善的回复…
发表回复
Jianli2004 2004-01-07
- 打赏
- 举报
对，不需要GROUP,一时糊涂
SELECT @sumdTotal= SUM(dMoney) FROM tblName
SELECT @sumdTotal= SUM(dMoney) FROM tblName
Chimae 2004-01-07
- 打赏
- 举报
谢谢xiaoliaoyun(流浪的云)！
xiaoliaoyun 2004-01-07
- 打赏
- 举报
SET @sumdTotal= (SELECT SUM(dMoney) FROM tblName)
Jianli2004 2004-01-07
- 打赏
- 举报
or
SET @sumdTotal= (SELECT SUM(dMoney) AS dTemp FROM tblName group by ...)
SET @sumdTotal= (SELECT SUM(dMoney) AS dTemp FROM tblName group by ...)
Jianli2004 2004-01-07
- 打赏
- 举报
SELECT @sumdTotal= SUM(dMoney) FROM tblName group by ...
Jianli2004 2004-01-07
- 打赏
- 举报
SET @sumdTotal= SELECT SUM(dMoney) AS dTemp FROM tblName group by ...
