Introduction
In this article I am sharing some SQL queries necessary for maintaining data in SQL Server for every developer.SQL
Get the related Stored Procedure to a tableSELECT DISTINCT o.name, o.xtypeFROM syscomments cINNER JOIN sysobjects o ON c.id=o.idWHERE c.TEXT LIKE '%Yourtablename%'Or you can use following querySELECT NameFROM sys.proceduresWHERE...
Posts
