dynamic SQL

Demystifying Dynamic SQL

Target Audience: This is for people who regularly write SQL code to solve varied problems, and who find themselves writing a lot of repetitive code, or frequently tweaking some code to fit new environments. You don’t need to know what dynamic SQL is to follow this talk. Abstract: Dynamic SQL is the name for SQL…
Read More

Dynamic Search Queries and How to Protect Them

Target Audience: Application DBA, SQL, T-SQL Programming, Stored Procedures Abstract: What is the solution for implementing truly dynamic search queries? Not just a stored procedure with optional parameters, but something even more dynamic than that? Let the end-user choose the exact fields and, more importantly, the operator types to use on them, in order to…
Read More