Dynamic SQL Archives - SQL Authority with Pinal Dave

SQL SERVER – Input and Output Parameter for Dynamic SQL – Simple Example

July 23, 2020

Dynamic SQL, SQL Performance, SQL Scripts, SQL Server

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.

SQL SERVER – Dynamic SQL and Temporary Tables

July 22, 2019

Pinal Dave

SQL Tips and Tricks

Dynamic SQL, SQL Scripts, SQL Server, SQL TempDB, SSMS, Temp Table

Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.

SQL SERVER – Dynamic SQL and Global Temporary Tables

July 20, 2019

Pinal Dave

SQL Tips and Tricks

Dynamic SQL, SQL Scripts, SQL Server, SQL TempDB, SSMS, Temp Table

During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.

SQL SERVER – Results of Dynamic SQL Into A Variable

November 20, 2018

Pinal Dave

SQL Tips and Tricks

Dynamic SQL, SQL Scripts, SQL Server, variable

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.