dbo.CCC_FindSQLStmt

SQL_STORED_PROCEDURE

Created 2026-04-14T14:19:50.727 · modified 2026-04-14T14:19:50.727 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@Searchstring`	nvarchar	no

Referenced objects

Schema	Object	Column/minor	Class
	DialogColumn		OBJECT_OR_COLUMN
	DialogTable		OBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1Create PROCEDURE [dbo].[CCC_FindSQLStmt] @Searchstring NVARCHAR(255)
2AS
3BEGIN
4       SET NOCOUNT ON;
5
6       DECLARE @tablename VARCHAR(30);
7       DECLARE @columnname VARCHAR(30);
8       DECLARE @sqlquery NVARCHAR(max);
9
10       DECLARE sqlcolumns CURSOR
11       FOR
12       SELECT dt.TableName
13              ,dc.ColumnName
14       FROM DialogColumn dc
15       JOIN DialogTable dt ON dc.UID_DialogTable = dt.UID_DialogTable
16       WHERE dc.SyntaxType LIKE 'SQL%';
17
18       OPEN sqlcolumns;
19
20       FETCH NEXT
21       FROM sqlcolumns
22       INTO @tablename
23              ,@columnname;
24
25       WHILE @@FETCH_STATUS = 0
26       BEGIN
27              PRINT @tablename + ': ' + @columnname;
28
29              SET @sqlquery = N'SELECT * FROM ' + @tablename + ' WHERE ' + @columnname + ' like ''%' + @Searchstring + '%''';
30
31              EXEC sp_executesql @sqlquery;
32
33              FETCH NEXT
34              FROM sqlcolumns
35              INTO @tablename
36                     ,@columnname;
37       END;
38
39       CLOSE sqlcolumns;
40
41       DEALLOCATE sqlcolumns;
42
43       SELECT TABLE_NAME
44              ,VIEW_DEFINITION
45              ,*
46       FROM INFORMATION_SCHEMA.VIEWS
47       WHERE VIEW_DEFINITION LIKE '%' + @Searchstring + '%'
48
49       SELECT ROUTINE_TYPE
50              ,SPECIFIC_NAME
51              ,ROUTINE_DEFINITION
52              ,*
53       FROM INFORMATION_SCHEMA.ROUTINES
54       WHERE ROUTINE_TYPE = 'PROCEDURE'
55              AND ROUTINE_DEFINITION LIKE '%' + @Searchstring + '%'
56
57       SELECT ROUTINE_TYPE
58              ,SPECIFIC_NAME
59              ,ROUTINE_DEFINITION
60              ,*
61       FROM INFORMATION_SCHEMA.ROUTINES
62       WHERE ROUTINE_TYPE = 'FUNCTION'
63              AND ROUTINE_DEFINITION LIKE '%' + @Searchstring + '%'
64
65       SELECT ST.name AS Tablename
66              ,TR.type_desc
67              ,TR.Name AS Triggername
68              ,SC.TEXT
69              ,TR.*
70       FROM sys.triggers TR
71       JOIN sys.syscomments SC ON TR.object_id = SC.id
72       JOIN sys.tables ST ON TR.parent_id = ST.object_id
73       WHERE SC.TEXT LIKE '%' + @Searchstring + '%'
74END
75

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T14:19:50.727

None extracted.

Summary: reads/joins DialogColumn, DialogTable, sqlcolumns, INFORMATION_SCHEMA, sys

Declared parameters

Parameter	Type	Direction
`@Searchstring`	`nvarchar(255)`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @Searchstring @tablename @columnname @sqlquery @FETCH_STATUS

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

No reverse dependencies extracted.