SQL
abbr. 结构化查询语言(Structured Query Language)
2026-03-22 11:12 浏览次数 24
abbr. 结构化查询语言(Structured Query Language)
SQL Injection资料隐码的入侵模式;资料隐码攻击
PL SQL游标
Recursive SQL概念
sql injection资料隐码的入侵模式;资料隐码攻击
SQL语言SQL language
SQL DDL数据定义语言
sql server数据库
sql serve数据库
SQL exit退出
SQL Codes实现代码
In DB2, variables of type array are like variables of any other SQL data types.
在DB 2中,类型阵列的变量类似于任何其他SQL数据类型的变量。
As I mentioned, SQL specifies what data to retrieve or manipulate, but does not specify how the database accomplishes these tasks.
如我所说的,SQL指定了要检索或操作什么数据,但没有指定数据库如何完成这些任务。
Relational databases provide the capability for the SQL statements to access information from more than one table through a joining of multiple tables.
关系数据库为sql语句提供了从一个以上的表中访问信息的能力,这是通过连接多个表来完成的。
Prepare to capture the information about the running SQL using one of the three procedure mentioned above.
準备使用上面提到的三种过程之一来获取关于正在运行的SQL的信息。
Referring back to Figure 1, you see how the abstract model generates one model for the SQL and another for the PHP through the Database access model.
回头看一看图1,就会发现抽象模型为sql生成了一个模型,又通过数据库访问模型为php生成了另一个模型。
The paradigm of SQL is that the user (or application) just tells the database system what to do and the system itself figures out the best way how to do it.
SQL的范例是,用户(或应用程序)只需告诉数据库系统要做什么,系统自己就会得出如何做 这件事的最佳方法。
It enables us to look at SQL statements by groups during an interval of time, then tune them as one.
它使我们能够在按组查看一段时间内的sql语句,然后并将它们作为一个整体进行调优。
Or one tenant could have additional SQL manipulation to restrict the data they could retrieve to records entered not more than 90 days before.
或者,某个租户可以进行额外的SQL操作,将它们可以检索的数据限制为最近90天以内输入的记录。
These features enable you to migrate SQL scripts from other database server products to DB2, either as is, or with minimal modifications.
这些特征可让您从其他数据库服务器产品移植sql脚本到DB2,即使是用最小的修改来移植。
SQL is a declarative language in the sense that only the data of interest is described in the program, not the algorithm for obtaining the data.
SQL在某种意义上来说是一种在程序中只描述感兴趣的数据的声明性语言,而不是为获得数据的算法。
Because this event monitor causes a lot of overhead on the monitored instance, these processes to create SQL reports should be started with consideration.
因为这个事件监视器会给监视的实例带来很大开销,所以在启动创建SQL报告的过程时要仔细考虑。
You can declare one or more condition handlers in your SQL procedure.
您可以在SQL过程中声明一个或多个条件处理程序。
For this example, you use some basic SQL functions to analyze the data.
对于本例来说,使用一些基本的SQL函数来分析数据。
External tables provide an easy and intuitive way to perform the unload and load operations through the SQL interface or stored procedures.
外部表特性提供了一种简单直观的方法来通过SQL界面或存储过程执行加载和卸载操作。
This means we will modify the basic CRUD SQL statements for each database.
这意味着对于每种数据库,我们将修改基本的CRUDsql语句。
I recommend using this method, as it gives you more information about the failure of the SQL statement.
我推荐使用这个方法,因为这个方法可以给出有关sql语句失败的更多信息。
Although different access paths for the same SQL statement produce the same result set, they most likely do not perform the task with the same level of performance.
虽然相同sql语句的不同访问路径会产生相同的结果集,但是它们很有可能不会通过同样的性能级别来执行任务。
With SQL replication, you create a configuration that specifies each table in the database that you want to replicate.
通过SQL复制,您可以创建一个配置,其中指定了您希望复制的每一个数据库表。
The transaction should fail and an SQL error should occur.
事务应该会失败,并且出现一个SQL错误。
The stored procedures return 0 (zero) when they run successfully and SQL error codes if it finds any issues with the parameters or policy file content.
如果成功运行,则存储过程将返回0(零),如果发现任何参数或策略文件内容问题,则返回SQL错误代码。
Next, he will analyze each transaction and explain the SQL features of each.
接着,他将分析每个事务,并解释每个事务的SQL特性。
Even choosing only a subset of the columns from the view would be a simple SQL query.
即使是只从视图中选择列的一个子集,也能用一个简单的SQL查询实现。
A good example are insert statements: if more than one row needs to be inserted into the same table, process all those rows together in a single SQL statement instead of firing several statements.
一个很好的例子就是insert语句:如果需要将多个行插入到相同的表中,那么是在一条sql语句中处理所有那些行,而不是触发多条语句。
This means you can get all the benefits of typical SQL join queries without the burden of predefining their relationships in the database layer.
这意味着您能够获得典型的SQL联合查询的所有好处,但又不需要在数据库层预定义它们的关系。