22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE PROC P(@WHERE NVARCHAR(4000))
AS
EXEC('SELECT * FROM TB '+@WHERE)
create procedure getList(@strFilter nvarchar(1000))
as
exec('select * from tb where ' + @strFilter)
go
create procedure getList(@strFilter nvarchar(1000))
as
exec('select * from tb where' + strFilter)
go