Answers for "search stored procedure in sql server"

SQL
2

how to search table name in stored procedure in sql server

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'
Posted by: Guest on May-26-2020
0

search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'
Posted by: Guest on October-30-2020
0

search stored procedures

SELECT DISTINCT
       o.name AS Object_Name,
       o.type_desc
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%[ABD]%';
Posted by: Guest on November-28-2019

Code answers related to "search stored procedure in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language