27/12/2021
Dynamic SQL Query and EXECUTE vs SP_EXECUTESQL:
---------------------------------------------------------------
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 have an effect on the result set of the dynamic SQL?
Q13. Can you use the variable declared outside the Dynamic SQL inside the Dynamic SQL Query?
Q14. Can you use Temp Table in Dynamic SQL Query?
Q15. Can you use the temp table created within the Dynamic SQL Query, outside the Dynamic SQL?
Q16. Can you return a value from the Dynamic SQL Query?
Q17. Can you use Dynamic SQL Query in Functions?
Q18. Can you use Transaction in Dynamic SQL Query?
Q19. Does Dynamic SQL Query re-use the cached plan?
Q20. What permission is required to execute the Dynamic SQL Query?
Q21. What is the QUOTENAME() function in SQL?
Q22. How can you check the dependent objects referenced in Dynamic SQL Query?
Q23. What are the Drawbacks of the Dynamic SQL?
Dynamic SQL Query - DSQL | EXECUTE vs sp_executesql | Static SQL vs Dynamic SQL
