某值被调用的地方



方法一：

select * from sys.sql_modules  where definition like '%wfpuser_a0430%'

方法二：

USE [WFP]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[WFP_SYS_SQLTest]

@filter = N'WFPUSER_T0130'

,@objname=N''

SELECT 'Return Value' = @return_value

GO

-----存储过程WFP_SYS_SQLTest

USE [wfp]

GO

/****** Object:  StoredProcedure [dbo].[WFP_SYS_SQLTest]    Script Date: 07/11/2016 14:39:02 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create  PROCEDURE [dbo].[WFP_SYS_SQLTest] @filter varchar(255),@objname varchar(255)

as

select objname,objjc,worktablesql ,'select'    from wfpsys_worktable

where worktablesql like '%'+@filter+'%' and (isnull(@objname,'')='' or objname =@objname)

union

select objname,objjc,worktableinsertsql ,'delete' from wfpsys_worktable where worktableinsertsql like '%'+@filter+'%'  and (isnull(@objname,'')='' or objname =@objname)

union

select objname,objjc,worktabledeletesql ,'delete' from wfpsys_worktable where worktabledeletesql like '%'+@filter+'%' and (isnull(@objname,'')='' or objname =@objname)

union

select objname,objjc,worktableupdatesql ,'update' from wfpsys_worktable where worktableupdatesql like '%'+@filter+'%' and (isnull(@objname,'')='' or objname =@objname)

union all

select distinct name,'存储过程',text,'存储过程' from sysobjects  a

join  syscomments  b

on a.id = b.id

and b.text like '%'+@filter+'%' and   (isnull(@objname,'')='' or name =@objname)

union all

select distinct name,'存储过程',text,'存储过程' from master..sysobjects  a

join  master..syscomments  b

on a.id = b.id

and b.text like '%'+@filter+'%' and   (isnull(@objname,'')='' or name =@objname)