03 2012 档案
在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) 推荐(0)