Today we are going to a very simple example of the Input and Output Parameter for Dynamic SQL. I have been working on SQL Server for almost 20 years.
During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
The other day during Comprehensive Database Performance Health Check, I was asked if there is a way to store results of dynamic SQL into a variable. This is a very popular question and let us see the answer to this question in this blog post.