LF1389C

--下面的存储过程用于在某个数据库中的所有表中查找某一字符串----使用: EXEC Search '阿三'CREATE PROCEDURE Search @Str varchar(100),@SearchFlag int=0,@TableFlag int=1/****@Str 要搜索的字符串**@TableFlag 1: 只在用户表中查找；2：只在系统表中查找;其他:...

/*name: trigger, procedure, view, function namextype: TR = trigger, P = procedure, V = view, FN = function*/Declare @SearchKey nvarchar(200)Set @SearchKey='BU'if @SearchKey=''beg...

declare @dbname nvarchar(200),@objid nvarchar(200)set @dbname='PETTY_CASH_ORIGIN'set @objid='PC_INVOICE_MASTER'Select a.req_spid,db_name(a.rsc_dbid) as 數據庫,object_name(a.rsc_objid) as 表,...