在分析常用的SQL数据操作语句结构的基础上,介绍了一个通用数据库操作模块的设计与实现。
Based on the analysis of the structure of common SQL data manipulation sentences, this paper introduces the designing andimplementation of a general database manipulation module.
在执行数据操作语句(像INSERT/UPDATE/DELETE)之后,使用TRY..CATCH结构或者检查该@@ERROR变量
Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
这种新的数据类型的优点是,它允许使用一条SELECT语句和传统的操作符(而不需要使用递归)在层次中进行搜索。
The advantage to this new data type is that it allows for searches within the hierarchy with a single SELECT statement, using traditional operators without recursion.
而且,它灵活,因为通过sql语句,有可能对XML数据应用许多操作。
And it is flexible, because through SQL statements it is possible to apply many operations on the XML data.
不管数据行是否被提交,以及根据语句的谓词它是否被排除,对于索引扫描和表访问都执行这样的锁定操作。
This locking was done for both index scans and table access whether or not the row of data was committed or whether it would have been excluded based on the statement's predicates.
某用户的用户名和口令,该用户拥有足够的权限启动和操作语句事件监视器,以及创建模式,而SQLProfiler将在该模式中保存其本地数据。
A user name and password for a user who has sufficient privileges to start and operate a statement event monitor as well as to create a schema where the SQL Profiler holds its local data.
但是,SELECT并非YQL支持的惟一SQL语句;您还可以使用INSERT、DELETE和UPDATE查询、运用相同的 SQL语法操作第三方服务上的数据。
SELECT, however, isn't the only SQL statement supported by YQL; you can also use INSERT, DELETE, and UPDATE queries to manipulate data on third-party services using the same SQL syntax.
您可以执行数据定义语言(DDL)和数据操作语言(dml)语句,并使用该工具来获取和显示结果。
You can execute both data definition language (DDL) and data manipulation language (DML) statements, and obtain and display the results using this tool.
在不同的数据库和操作系统中,动态语句高速缓存的激活是不同的。
The activation of dynamic statement caching will vary with database and operating system.
选择操作之后,可以启动元数据浏览器,选择要进行查询的业务对象,也可以手动输入对象名称和soql语句。
After the operation is selected, you can either launch the metadata browser to select the business object that you want to query on, or manually enter the object name and SOQL statement.
在使用CREATEdatabase语句创建数据库时,将从操作系统的地区设置推导出数据库的编码页。
When you create a database using the create database statement, the code page for the database will be derived from the operating system locale setting.
在这种情况下,return操作符的细节包括被传递到远程数据源的远程sql语句的文本。
In this case, the details of the RETURN operator contain the text of the remote SQL statement that is passed to the remote data source.
该特性扩展了IDS的功能,使其可以不去修改查询语句,以保证与其他符合SQL标准数据库服务器的互操作性。
This feature expands the capability of IDS to run without modification queries that are interoperable on other database servers that support industry-standard SQL syntax.
一种从输入设备提交到操作系统的作业控制语句和数据的序列。
A sequence of job control statements and data submitted to an operating system from an input unit.
Hibernate生成sql语句字符串并使用JDBC准备和执行操作在数据库中执行它们。
Hibernate generates the SQL statement strings and executes them against the database using the JDBC prepare and execute operations.
这些用户帐号可以在Linux操作系统上创建,然后使用grant语句给它们分配正确的数据库权限。
These user accounts can be created on the Linux operating system, and GRANT statements are used to assign them the correct database privileges.
通过这个解决方案,将数据库语句公布为Web服务操作非常简单,只需将sql语句或存储过程拖放到一个Web服务文件夹中。
With this solution, exposing a database statement as Web service operation is as simple as dragging and dropping an SQL statement or stored procedure into a Web service folder.
SHIP操作符没有相关联的语句,因为这个 SHIP 操作符表示将数据从联邦服务器传送到Oracle。
The SHIP operator does not have a statement associated with it, as this SHIP operator stands for transferring data from the federated server to Oracle.
最后,在这个事务中还暴露了有关数据更改操作的另一个更新颖的特性:那就是INCLUDE -子句,像任何其他数据更改语句一样,INSERT可以使用这个子句。
Finally, there is one more novel feature related to data-change-operations exposed in this transaction: the INCLUDE-clause which INSERT, like any other data-change-operation, can use.
当创建这个查询时,SQL语句并没有被发送到数据库中,只有当你在代码中对这个IQueryable对象进行Iterate操作时,这个SQL语句才会被创建并执行,这个概念就是延迟执行。
At the moment the query is created, no SQL statement is issued to the database. The SQL statement is created and executed when your code iterates the IQueryable object.
查询是数据库应用系统中使用最频繁的操作,查询语句的优劣直接影响数据库应用系统的性能。
Enquiry is frequently used in data base application system which depends on whether the enquiry statement is superior or inferior.
用算数运算符操作数字与时间数据来创建语句。
Create expressions with number and date data by using arithmetic operators.
使用标准的SQL语句和JDBCAPI来完成对数据库进行读取和写入操作。
The reading and writing on database with standard SQL sentence and JDBC API can be made.
说明:非常简单的数据库代码并附上报告,实现的功能是用SQL语句完成整个查询操作。
Very simple database code along with the report, the function is to use SQL statements to complete the query operations.
同样,用户还可以输入SQL查询语句并查看这些查询操作产生的列表数据。
Equally, user can also input SQL inquire the sentence and look over that these are inquired about and operate the tabular data produced .
为执行许多的操作,数据库控制台向数据库提交sql语句。
To perform many of its operations, Oracle Enterprise Manager Database Control (Database Control) submits structured query language (SQL) statements to the database.
说明:数据库中图片全操作易语言源码例程程序使用执行SQL语句实现MDB数据库中图片全操作。
Image database routines full operation easy language source programs use SQL statements executed pictures in full operation MDB database.
SQL语句通常用于完成一些数据库的操作任务,比如在数据库中更新数据,或者从数据库中检索数据。
SQL statements are usually used to complete some tasks of database operations, such as updating the database data or from the database retrieval of data.
sql语句可以用来执行各种各样的操作,例如更新数据库中的数据,从数据库中提取数据等。
SQL statements can be used to perform various operations, such as updating data in the database, extract data from the database and so on.
为了加快查询的执行,我们对存放在关系库中的XML数据建立结构化映射,以减少SQL语句中连接操作的数目。
In order to speed up the query evaluation, we established the structured mapping for the XML data stored in RDB, and therefore, the frequency of join operations in SQL statement can be decreased.
应用推荐