CREATE Procedure Sp_cljl
@a char(50)
AS
declare @tmp varchar(255)
select @tmp='select * from M_GYB_CK_CKJL where gcmc like ''%'+rtrim(ltrim(@a))+'%'' OR lydw LIKE ''%'+rtrim(ltrim(@a))+'%'''
exec(@tmp)
GO
@a char(50)
AS
declare @tmp varchar(255)
select @tmp='select * from M_GYB_CK_CKJL where gcmc like ''%'+rtrim(ltrim(@a))+'%'' OR lydw LIKE ''%'+rtrim(ltrim(@a))+'%'''
exec(@tmp)
GO
@a char(50)
AS
declare @tmp varchar(255)
select @tmp='select * from M_GYB_CK_CKJL where gcmc like ''%'+@a+'%'' OR lydw LIKE ''%'+@a+'%'''
exec(@tmp)
GO
@a char(50)
AS
declare @tmp nvarchar(255)
select @tmp='select * from M_GYB_CK_CKJL where gcmc like ''%'+@a+'%'' OR lydw LIKE ''%'+@a+'%'''
exec sp_executesql @tmp
GO
''==='