(Pinal Dave) 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.
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help