declare @count int SELECT a,b,@count=COUNT(*) R FROM TB WHERE a=10 AND b=20 GROUP BY a,b
declare @count int SELECT a,b,@count=COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b
declare @cnt int SELECT a,b,@cnt=COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b print @cnt
不知道你是要什么结果集?是单个值,直接付给变量即可。如下:declare @count int SELECT @count=COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b
declare @xml xml set @xml=(SELECT a,b,COUNT(*) R FROM TB WHERE a=10 AND b=20 GROUP BY a,b for xml path('root'))select @xml 赋值结果集时这样用
declare @count int set @count=(select COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b)
你的值如果只有一个,则可以使用变量. declare @cnt as intSELECT @cnt = COUNT(*) FROM TB WHERE a=10 AND b=20或者set @cnt = (SELECT COUNT(*) FROM TB WHERE a=10 AND b=20)而你原来的语句如果存在多个值,则不建议这么用. SELECT a,b,@cnt = COUNT(*) R FROM TB WHERE a=10 AND b=20 GROUP BY a,b SELECT a,b,@cnt = COUNT(*) R FROM TB GROUP BY a,b ...
SELECT a,b,@count=COUNT(*) R FROM TB WHERE a=10 AND b=20 GROUP BY a,b
SELECT a,b,@count=COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b
declare @cnt int
SELECT a,b,@cnt=COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b
print @cnt
SELECT @count=COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b
set @xml=(SELECT a,b,COUNT(*) R FROM TB WHERE a=10 AND b=20 GROUP BY a,b for xml path('root'))select @xml
赋值结果集时这样用
set @count=(select COUNT(*) FROM TB WHERE a=10 AND b=20 GROUP BY a,b)
declare @cnt as intSELECT @cnt = COUNT(*) FROM TB WHERE a=10 AND b=20或者set @cnt = (SELECT COUNT(*) FROM TB WHERE a=10 AND b=20)而你原来的语句如果存在多个值,则不建议这么用.
SELECT a,b,@cnt = COUNT(*) R FROM TB WHERE a=10 AND b=20 GROUP BY a,b
SELECT a,b,@cnt = COUNT(*) R FROM TB GROUP BY a,b
...