请问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.但是要把变量改为实际值,却能够返回正确值,