且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

什么是动态SQL查询,什么时候要使用它?

更新时间:2023-02-16 22:46:03

这里有几篇文章:

  • Introduction to Dynamic SQL
  • Dynamic SQL Beginner's Guide

动态SQL入门


动态SQL 是一个术语,用于表示由您以编程方式(部分或全部)生成的SQL代码程序在执行之前。结果,它是一个非常灵活而强大的工具。您可以使用动态SQL完成诸如根据表单上填写的字段在搜索中添加where子句或创建具有不同名称的表之类的任务。

Dynamic SQL is a term used to mean SQL code that is generated programatically (in part or fully) by your program before it is executed. As a result it is a very flexible and powerful tool. You can use dynamic SQL to accomplish tasks such as adding where clauses to a search based on what fields are filled out on a form or to create tables with varying names.