请问sql 专家一个检索语句的问题

请问sql 专家一个检索语句的问题
select @n1 = count(*) from windbreaker where name like '%'+ @w1+'%'
select @n2 = count(*) from windbreaker where name like '%'+ @w1+'%'
select @n3 = count(*) from windbreaker where name like '%'+ @w1+'%'+@w2+'%'
select @n4 = count(*) from windbreaker where name like '%'+ @w2+'%'+@w1+'%'
我写了如下检索语句,但是检索结果却是0.但是要把变量改为实际值,却能够返回正确值,
josmen 1年前 已收到1个回答 举报

juriee 幼苗

共回答了10个问题采纳率:90% 举报

declare @sql varchar(4000);
set @sql='select '+@n1+' count(*) from windbreaker where name like '''%'+@w1+'%''';
exec @sql;
set @sql='select '+@n2+' count(*) from windbreaker where name like '''%'+@w1+'%''';
exec @sql;
set @sql='select '+@n3+' count(*) from windbreaker where name like '''%'+@w1+'%'+@w2+'%'
'';
exec @sql;
set @sql='select '+@n4+' count(*) from windbreaker where name like '''%'+@w2+'%'+@w2+'%'
'';
exec @sql;

1年前

7
可能相似的问题
Copyright © 2024 YULUCN.COM - 雨露学习互助 - 16 q. 0.030 s. - webmaster@yulucn.com