摘要： if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_search]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[p_search] GO /*--在整个数据库搜索某个字符串在哪个表的哪个字段中 /*--调用示例 ... 阅读全文

摘要： declare @row varchar(30)declare @tbname varchar(30) DECLARE string_find_cursor CURSOR FAST_FORWARD FOR SELECT [name] FROM sysobjects where type='U' and name like 'A%' ORDER BY [name] OPEN string_fi... 阅读全文