ALTER PROCEDURE [dbo].[sp_CommSelect]
@ParamName VARCHAR(2000),/*查询字段字符串*/@TableName VARCHAR(2000),/*表名*/@ParamWhere NVARCHAR(2000)/*条件字符串*/AS BEGINDECLARE @Sql VARCHAR(5000)set @Sql='select from where 1=1 and
exec(@Sql)END本文共 279 字,大约阅读时间需要 1 分钟。
ALTER PROCEDURE [dbo].[sp_CommSelect]
@ParamName VARCHAR(2000),/*查询字段字符串*/@TableName VARCHAR(2000),/*表名*/@ParamWhere NVARCHAR(2000)/*条件字符串*/AS BEGINDECLARE @Sql VARCHAR(5000)set @Sql='select from where 1=1 and
exec(@Sql)END转载于:https://www.cnblogs.com/DxiaoJ/p/4047120.html