SELECT DISTINCT obj.Name 存储过程名,xtype
FROM syscomments sc
INNER JOIN sysobjects obj ON sc.Id = obj.ID
WHERE sc.TEXT LIKE '%PL_EndCon%'
sqlserver查看存储过程是否包含某个字段
于 2022-01-19 14:19:56 首次发布
SELECT DISTINCT obj.Name 存储过程名,xtype
FROM syscomments sc
INNER JOIN sysobjects obj ON sc.Id = obj.ID
WHERE sc.TEXT LIKE '%PL_EndCon%'