22,211
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE arkkccx
(
@cxtj varchar(200)
)
as
DECLARE @STRING1 varchar(200)
set @string1='SELECT hh as 货号,mc as 名称,kk as 款号 from ark where ' +@cxtj
exec(@string1)
GO
调用:
exec arkkccx 'mc=''eee'' and hh=''sss'' and kk=''ff'''
CREATE PROCEDURE arkkccx
(
@cxtj varchar(200)
)
as
DECLARE @STRING1 varchar(200)
set @string1='SELECT hh as 货号,mc as 名称,kk as 款号 from ark where ' +@cxtj
exec(@string1)
GO