create procedure p
@tableName varchar(20), --表名
@colName varchar(10), --列名
@str varchar(20) --要搜索的字符串
as
declare @sql nvarchar(200)
set @sql=N'select * from '+@tableName+
N' where '+@colName+
N' like ''%''+@str+''%'''
exec sp_executesql @sql,N'@str varchar(20)',@str
go
@tableName varchar(20), --表名
@colName varchar(10), --列名
@str varchar(20) --要搜索的字符串
as
declare @sql nvarchar(200)
set @sql=N'select * from '+@tableName+
N' where '+@colName+
N' like ''%''+@str+''%'''
exec sp_executesql @sql,N'@str varchar(20)',@str
go
select * from tablename where aa like '%'+ @bb +'%'
@tableName varchar(20), --表名
@colName varchar(10), --列名
@str varchar(20) --要搜索的字符串
as
declare @sql nvarchar(200)
set @sql=N'select * from '+@tableName+
N' where '+@colName+
N' like ''%''+@str+''%'''
exec sp_executesql @sql,N'@str varchar(20)',@str
goN'到底是什么意思
set @sql=select * from '+@tableName+' where '+@colName+' like ''%'+@str+''%''
我这样写可不可以呀,谢谢了
declare @sql varchar(200)
set @str='鱼'
set @sql='select * from T_MenuKind where mk_name like ''%'+@str+'%'''
print @sql
exec (@sql)
set @sql=select * from '+@tableName+' where '+@colName+' like ''%'+@str+''%''
=======〉也可以