Friday 28 October 2016

Find the Given text in sp in sql server

With the help of below sql script we can find the given text in SP.
SELECT
 OBJECT_NAME(object_id) as [SP Name],
  OBJECT_DEFINITION(object_id) as [desc]
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%ProductAssemblyID%'
See the output

In both SP have this Text.



No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts