MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will provide information about finding which Stored Procedures a table is used in in SQL Server. In SQL Server in some cases you may want to find out which Stored Procedures a table is used in. You can easily do this using the...
Hello to everyone, In this article, I will talk about how to find the tables used by Stored procedures in SQL Server. You can easily do this using the code below. DECLARE @temptableforSP TABLE ( spName VARCHAR(100), tableName NVARCHAR(100) ); DECLARE @SP_Name AS NVARCHAR(100); DECLARE @SP_Cursor AS CURSOR; SET @SP_Cursor...