在DB中查找所有表的字符串字段是否有指定值
摘要:declare @TableName nvarchar(100),@ColName nvarchar(100),@SQL nvarchar(4000),@TableID int,@FindValue nvarchar(100)SET @FindValue = 'sp_CopyInterventionDffToInspectionReportDff'DECLARE TCur CursorFOR SELECT NAME,ID FROM sysobjectsWHERE Xtype = 'U'OPEN TCurFETCH NEXT FROM TCur INTO @Tab
阅读全文
posted @
2012-03-15 09:21
黑暗之眼
阅读(328)
推荐(0)