sql 语句错误,请大哥大姐们帮忙看一下

[wubaowang]

DECLARE @name varchar(50)
DECLARE @smsCount int
DECLARE @DataString datetime
DECLARE @s nvarchar(200)

set @DataString = getdate()-3
set @name='资料40000'

if EXISTS(select TABLE_Name from information_schema.tables where TABLE_Name='temp')
begin
drop table temp
end
set @s='SELECT * into temp FROM '+ @name +' where datediff(d,'''+ cast(@DataString as nvarchar(25))+''',日期)=0'
exec(@s)
-- print @s
--select * from temp

set @smsCount=(select * from temp)

print @smsCount



--------------------------------------------

错误提示
消息 116，级别 16，状态 1，第 23 行
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

[kk19840210]

set @smsCount=(select * from temp)



这地方错了


set @smsCount=(select count(*) from temp)

试下

[-狙击手-]

[Quote=引用 1 楼 kk19840210 的回复:]
set @smsCount=(select * from temp)


这地方错了


set @smsCount=(select count(*) from temp)

试下
[/Quote]

[fcuandy]

是这个地方错了，至于怎么改要看楼主希望@smscount能得到什么了。估计可能像楼上那样。

[晓风残月0110]

同一小虫
set @smsCount=(select * from temp)

将seleclt 的多个值给变量@smsCount不允许

[wzy_love_sly]

select @smsCount=count(*) from temp

[nzperfect]

set @smsCount=(select * from temp)

-->

select @smsCount=count(*) from temp

[liangCK]

[Quote=引用 4 楼 charry0110 的回复:]
同一小虫
set @smsCount=(select * from temp)

将seleclt 的多个值给变量@smsCount不允许
[/Quote]