Dynamic SQL By Edward Pollack

About The E-Book

Title – Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server
Author – Edward Pollack
Total Pages – 508 Pages
Total Chapters – 12 Chapters
E-Book Size – 10 MBs

Investigate the various applications of dynamic SQL in Microsoft SQL Server. This edition has been updated to take use of SQL Server 2016 and SQL Server 2017 most recent capabilities as well as to take into account how analytics and database administration are evolving. To increase productivity and maintainability, new system objects and functions have been added to the code samples.

For large scale searching based on user entered criteria, SQL execution is essential. SQL may generate lists of values and even code with little to no performance cost. Business intelligence programs can dynamically pivot data, and SQL allows for customization of database objects. Dynamic SQL, however, is feared by many due to concerns about SQL injection or code maintainability.