sql 语句 like 用法？

[lflsg]

sqlstr = "select TOP " + itempage.ToString() + " * FROM bmlist where id NOT IN ( select TOP " + (itempage * (page - 1)).ToString() + " id FROM bmlist where rename=@rename and hdid=@hdid " + orderby + ") and rename=@rename and hdid=@hdid" + orderby;

上面的查询结果是精确查询，可以正确查询出结果，
下面是我改成 用 like 模糊查询，但是查询失败，没有查询结果

sqlstr = "select TOP " + itempage.ToString() + " * FROM bmlist where id NOT IN ( select TOP " + (itempage * (page - 1)).ToString() + " id FROM bmlist where rename=@rename and hdid=@hdid " + orderby + ") and rename like ‘%@rename%’ and hdid=@hdid" + orderby;

请教大神了？

[xdashewan]

在赋值@rename的地方拼%，sql里不用拼

[sinat_33410993]

rename like ‘%@rename%’ ‘%‘+@rename+’%’ 试一下

[lflsg]

引用 2 楼 xdashewan 的回复:

在赋值@rename的地方拼%，sql里不用拼

cmd.Parameters["@rename"].Value ="'%"+ keys+"%'"; 赋值拼接也不行呀？

[江南小鱼]

 sqlstr = "select TOP " + itempage.ToString() + " * FROM bmlist where id NOT IN ( select TOP " + (itempage * (page - 1)).ToString() + " id FROM bmlist where rename=@rename and hdid=@hdid " + orderby + ") and rename like ‘%'"+@rename+"'%’  and hdid=@hdid" + orderby;

[起个好昵称怎么这么难呢]

引用 3 楼 lflsg的回复:

[quote=引用 2 楼 xdashewan 的回复:] 在赋值@rename的地方拼%，sql里不用拼

cmd.Parameters["@rename"].Value ="'%"+ keys+"%'"; 赋值拼接也不行呀？[/quote] 少写了单引号“‘%’”

[秋的红果实]

like ‘%@rename%’ 改成： like ‘%'+@rename%+'%' 这里的+，是提交给SQL的运算符，不是C#里的，T-SQL有自己完整运算体系

[正怒月神]

6楼正解