MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about querying whether there is a Stored Procedure in SQL Server. In SQL Server you may want to query if there is a Stored Procedure in some cases. You can easily do this using the code below. SELECT *...
Hello everyone, In this article, I will try to give information about displaying Stored Procedure parameters in SQL Server in detail. In SQL Server, in some cases, you may want to view the Stored Procedure parameters in detail. You can easily do this using the code below. SELECT ‘Parameter_name’ =...
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...