Say you want to find all the stored procedures that have the text-'EmployeeNo' , here's how to go about it .
SELECT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE [text] LIKE '%EmployeeNo%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id)
SQL-Search Stored Procedures For A Text
Say you want to find all the stored procedures that have the text-'EmployeeNo' , here's how to go about it .
SELECT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE [text] LIKE '%EmployeeNo%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id)
0 Komentar