动态存储过程中like语句
if exists(select * from sysobjects where name='GetNewsCount' and type='p')
drop proc GetNewsCount
go
CREATE PROCEDURE GetNewsCount
@table varchar(60)
@title varchar(200)
as
declare @sql varchar(60)
set @sql=' select count(*) from '+rtrim(@table)+' where title like '+'%'+@title+'%'
exec (@sql)
GO
就是想把表名弄成动态的 但是后面的like语句要出问题
例如 select count(*) from tablename where title like 'content' 就是说 tablename 和title是动态的
该这么些啊 指点下