Dynamic SQL Query - DSQL | EXECUTE vs sp_executesql | Static SQL vs Dynamic SQL

Dynamic SQL Query - DSQL | EXECUTE vs sp_executesql | Static SQL vs Dynamic SQL | Unicode vs Non-Unicode type OUT parameter in D-SQL | WITH RESULT SETS in DSQL | WITH RECOMPILE hint in DSQL | NULL values in D-SQL Agenda: -------- Q01. What is Dynamic SQL Query? Q02. What is the difference between Static SQL and Dynamic SQL Query? Q03. How can you run the Dynamic SQL Query? Q04. What is the difference between EXECUTE, EXECUTE() and sp_executesql? Q05. Can you use the OUT parameter in a Dynamic SQL Query? Q06. Can you pass OUT parameters in EXEC()? Q07. Can you use VARCHAR or CHAR data type (Non-Unicode) for preparing the Dynamic SQL Query for the sp_executesql? Q08. Does Dynamic SQL Query handle the NULL values? Q09. What is the use of WITH RECOMPILE hint in Dynamic SQL Query? Q10. Can you use WITH RESULT SETS option in a Dynamic SQL Query? Q11. What is the scope of the Dynamic SQL Query? Q12. Does the SET Statements configure before the Dynamic SQL will hav