Back to OIM Explorer

dbo.CCC_FindSQLStmt

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 2.140 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL72 lines
1CREATE PROCEDURE [dbo] . [CCC_FindSQLStmt] @Searchstring NVARCHAR(2  2553)4AS5BEGIN6  SET NOCOUNT7    ON ;8  DECLARE @tablename VARCHAR(30);9  DECLARE @columnname VARCHAR(30);10  DECLARE @sqlquery NVARCHAR(max);11  DECLARE sqlcolumns CURSOR FOR12  SELECT13    dt.TableName,14    dc.ColumnName15  FROM DialogColumn dc16  JOIN DialogTable dt17    ON dc.UID_DialogTable = dt.UID_DialogTable18  WHERE19    dc.SyntaxType LIKE 'SQL%';20  OPEN sqlcolumns;21  FETCH NEXT22  FROM sqlcolumns INTO @tablename,23  @columnname;24  WHILE @@FETCH_STATUS = 025  BEGIN26    PRINT @tablename + ': ' + @columnname;27    SET @sqlquery = N 'SELECT * FROM ' + @tablename + ' WHERE ' + @columnname + ' like ''%' + @Searchstring + '%''';28    EXEC sp_executesql @sqlquery;29    FETCH NEXT30    FROM sqlcolumns INTO @tablename,31    @columnname;32  END33  ;34  CLOSE sqlcolumns;35  DEALLOCATE sqlcolumns;36  SELECT37    TABLE_NAME,38    VIEW_DEFINITION,39    *40  FROM INFORMATION_SCHEMA.VIEWS41  WHERE42    VIEW_DEFINITION LIKE '%' + @Searchstring + '%'43  SELECT44    ROUTINE_TYPE,45    SPECIFIC_NAME,46    ROUTINE_DEFINITION,47    *48  FROM INFORMATION_SCHEMA.ROUTINES49  WHERE50    ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_DEFINITION LIKE '%' + @Searchstring + '%'51  SELECT52    ROUTINE_TYPE,53    SPECIFIC_NAME,54    ROUTINE_DEFINITION,55    *56  FROM INFORMATION_SCHEMA.ROUTINES57  WHERE58    ROUTINE_TYPE = 'FUNCTION' AND ROUTINE_DEFINITION LIKE '%' + @Searchstring + '%'59  SELECT60    ST.name AS Tablename,61    TR.type_desc,62    TR.Name AS Triggername,63    SC.TEXT,64    TR.*65  FROM sys.triggers TR66  JOIN sys.syscomments SC67    ON TR.object_id = SC.id68  JOIN sys.tables ST69    ON TR.parent_id = ST.object_id70  WHERE71    SC.TEXT LIKE '%' + @Searchstring + '%'72END
Open raw exported source
SQL ยท Raw77 lines
123Create PROCEDURE [dbo].[CCC_FindSQLStmt] @Searchstring NVARCHAR(255)4AS5BEGIN6       SET NOCOUNT ON;78       DECLARE @tablename VARCHAR(30);9       DECLARE @columnname VARCHAR(30);10       DECLARE @sqlquery NVARCHAR(max);1112       DECLARE sqlcolumns CURSOR13       FOR14       SELECT dt.TableName15              ,dc.ColumnName16       FROM DialogColumn dc17       JOIN DialogTable dt ON dc.UID_DialogTable = dt.UID_DialogTable18       WHERE dc.SyntaxType LIKE 'SQL%';1920       OPEN sqlcolumns;2122       FETCH NEXT23       FROM sqlcolumns24       INTO @tablename25              ,@columnname;2627       WHILE @@FETCH_STATUS = 028       BEGIN29              PRINT @tablename + ': ' + @columnname;3031              SET @sqlquery = N'SELECT * FROM ' + @tablename + ' WHERE ' + @columnname + ' like ''%' + @Searchstring + '%''';3233              EXEC sp_executesql @sqlquery;3435              FETCH NEXT36              FROM sqlcolumns37              INTO @tablename38                     ,@columnname;39       END;4041       CLOSE sqlcolumns;4243       DEALLOCATE sqlcolumns;4445       SELECT TABLE_NAME46              ,VIEW_DEFINITION47              ,*48       FROM INFORMATION_SCHEMA.VIEWS49       WHERE VIEW_DEFINITION LIKE '%' + @Searchstring + '%'5051       SELECT ROUTINE_TYPE52              ,SPECIFIC_NAME53              ,ROUTINE_DEFINITION54              ,*55       FROM INFORMATION_SCHEMA.ROUTINES56       WHERE ROUTINE_TYPE = 'PROCEDURE'57              AND ROUTINE_DEFINITION LIKE '%' + @Searchstring + '%'5859       SELECT ROUTINE_TYPE60              ,SPECIFIC_NAME61              ,ROUTINE_DEFINITION62              ,*63       FROM INFORMATION_SCHEMA.ROUTINES64       WHERE ROUTINE_TYPE = 'FUNCTION'65              AND ROUTINE_DEFINITION LIKE '%' + @Searchstring + '%'6667       SELECT ST.name AS Tablename68              ,TR.type_desc69              ,TR.Name AS Triggername70              ,SC.TEXT71              ,TR.*72       FROM sys.triggers TR73       JOIN sys.syscomments SC ON TR.object_id = SC.id74       JOIN sys.tables ST ON TR.parent_id = ST.object_id75       WHERE SC.TEXT LIKE '%' + @Searchstring + '%'76END77