比较简单的问题，就是我不会，请求各位大哥

[daqi2010]

declare @sql2 varchar(4000)
DECLARE @asql varchar(500)
DECLARE @msql varchar(500)
DECLARE @reinfo varchar(500)
set @sql2='where 1=1'
set @asql='select count(chance_id) from chance A ' +@sql2+' '
set @msql='select count(chance_money) from chance A ' +@sql2+' '

执行@asql和@msql最终得到
set @reinfo=5|125.00
请问各位大哥如何写

[SQL77]

125.00


不知道你的.00是怎么来的

[SQL77]

set @asql='select count(chance_id) from chance A ' +@sql2+' '
set @msql='select count(chance_money) from chance A ' +@sql2+'

如果是同一个表,数量应该相等吧

[jiangshun]

--直接这样写不行吗？
DECLARE @reinfo varchar(500)
set @reinfo=rtrim(select count(chance_id)  from chance)+'|'+rtrim(select count(chance_money)  from chance)

[百年树人]

根据我不专业的判断，我觉得你第二个应该sum，而不是count

declare @sql2 nvarchar(4000) 
DECLARE @asql nvarchar(500) 
--DECLARE @msql varchar(500)
declare @c1 int,@c2 dec(18,2)
select @c1=0,@c2=0

set @sql2='where 1=1' 
set @asql=N'select @c1=count(chance_id),@c2=sum(chance_money)  from chance A ' +@sql2+' ' 

exec sp_executesql @asql,N'@c1 int,@c2 dec(18,2) output',@c1,@c2 output;

select ltrim(@c1)+'|'+ltrim(@c2)

[百年树人]

[Quote=引用 4 楼 josy 的回复:]
根据我不专业的判断，我觉得你第二个应该sum，而不是count
SQL codedeclare@sql2nvarchar(4000)DECLARE@asqlnvarchar(500)--DECLARE @msql varchar(500)declare@c1int,@c2dec(18,2)select@c1=0,@c2=0set@sql2='where 1=1'set@asql=N'select @c1=count(chance_id),@c2=sum(chance_money) from chance A'+@sql2+''exec sp_executesql@asql,N'@c1 int,@c2 dec(18,2) output',@c1,@c2 output;selectltrim(@c1)+'|'+ltrim(@c2)
[/Quote]
修正一点笔误

declare @sql2 nvarchar(4000) 
DECLARE @asql nvarchar(500) 
--DECLARE @msql varchar(500)
declare @c1 int,@c2 dec(18,2)
select @c1=0,@c2=0

set @sql2='where 1=1' 
set @asql=N'select @c1=count(chance_id),@c2=sum(chance_money)  from chance A ' +@sql2+' ' 

exec sp_executesql @asql,N'@c1 int output,@c2 dec(18,2) output',@c1 output,@c2 output;

select ltrim(@c1)+'|'+ltrim(@c2)