34,591
社区成员
发帖
与我相关
我的任务
分享
create proc spClientInf @ClientName varchar(8) = '%',
as
exec('select * from tClient where cname like ''%/' + @clientname + '%'' escape ''/''')
go
create table tClient(cname varchar(10))
insert tClient select '50%'
go
alter proc spClientInf @ClientName varchar(8) = '%'
as
exec('select * from tClient where cname like ''%/' + @clientname + '%'' escape ''/''')
go
exec spClientInf
/*
cname
----------
50%
(1 行受影响)
*/
create proc spClientInf @ClientName varchar(8) = '%',
as
exec('select * from tClient where cname like ''%/' + @clientname + '%'' escape ''/''')
go