这个我知道 create procedure hehe @keyword varchar(30)='%' as select * from 表 where 字段 like @keyword
----如果入口参数定义为char declare @keyWord char(10) set @keyWord='aa' set @keyWord='%'+Ltrim(RTrim(@keyWord))+'%' select * from tabName where filename like RTrim(@keyWord)----如果入口参数定义为varchar declare @keyWord varchar(10) set @keyWord='aa' set @keyWord='%'+@keyWord+'%' select * from tabName where filename like @keyWord
@keyword char
AS
select * from tab where a like @keyword
select @sqlstr='select * from tablename where 字段一 like '+''''+@keyword+''''
exec(sqlstr)
create procedure hehe
@keyword varchar(30)='%'
as
select * from 表 where 字段 like @keyword
declare @keyWord char(10)
set @keyWord='aa'
set @keyWord='%'+Ltrim(RTrim(@keyWord))+'%'
select * from tabName where filename like RTrim(@keyWord)----如果入口参数定义为varchar
declare @keyWord varchar(10)
set @keyWord='aa'
set @keyWord='%'+@keyWord+'%'
select * from tabName where filename like @keyWord