The best replacement for dynamic sql is static sql.


The best alternatives to dynamic sql are rated as following:
★★★★★  static sql
★★★  stored procedures
★★★  stored procedure
★★  stored procs
★  parameterized queries
★  embedded sql
  stored proc

Your alternative for dynamic sql is not listed? Suggest!
Speaking about dynamic sql, one probably shouldn't forget about output parameter.

Other search terms related to dynamic sql and their ratings are:

★★★★★ output parameter
★★★★★ table variable
★★★★ cte
★★★ temp tables
temp table
bulk collect
bind variables
You have in mind a companion for dynamic sql and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of dynamic sql in all years. Click on graph for more.
dynamic sql
static sql
stored procedures