创建以个查询的存储过程进行模糊查询
查询 语句 select *from V_InfoAndUser where title like '%学习%'
怎么是“学习”那变成参数呢???
变成
select *from V_InfoAndUser where title like '%参数(@title)%'
主要是怎么拼接???????
------解决方案--------------------
- SQL code
select *from V_InfoAndUser where title like [email protected]+'%'
------解决方案--------------------
select * from V_InfoAndUser where title like [email protected]+'%'
------解决方案--------------------
select *from V_InfoAndUser where title like [email protected]+'%'