execute

Change stored procedure output column names and data types

2 Comments / SQL Server / / /

Can we change the output column name and their data type being received from a stored procedure during execution? Yes, SQL Server 2012 introduced “WITH RESULT SETS” option which can be used with EXECUTE command to redefine the metadata of result sets being received from stored procedures. This option can handle single as well as multiple result sets. […]

Change stored procedure output column names and data types Read More »

sp_executesql vs execute in SQL Server

4 Comments / SQL Server / / / ,

In this post “SP_EXECUTESQL vs Execute”, we are going to compare sp_executesql and execute in SQL Server. Apart from differences, we will also discuss the similarities between sp_executesql and execute commands. Lets start with few questions like, What is the difference between Execute and sp_ExecuteSQL? How can we execute a T-SQL String? Similarities between Execute and sp_ExecuteSQL.

sp_executesql vs execute in SQL Server Read More »