if object_id('P_test')is not null
drop proc P_test
go
create proc P_test
@col varchar(20),
@search varchar(20)
as
declare @s varchar(6000)
set @s='select * from test where '+ @col+ ' like ''%'+@search+'%'''
exec(@s)
go
exec p_test 'ckh','aa'
drop proc P_test
go
create proc P_test
@col varchar(20),
@search varchar(20)
as
declare @s varchar(6000)
set @s='select * from test where '+ @col+ ' like ''%'+@search+'%'''
exec(@s)
go
exec p_test 'ckh','aa'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货