This topic lists the programmability enhancements that have been made to full - text search , such as the data definition language for full - text search and the ability to specify languages in queries other than the default language 本主题列出了对全文搜索的可编程性增强,如用于全文搜索的数据定义语言和在查询中指定非默认语言的功能。
A stored procedure can take input parameters , return tabular or scalar results and messages to the client , invoke data definition language and data manipulation language statements , and return output parameters 存储过程可以接受输入参数、向客户端返回表格或标量结果和消息、调用数据定义语言( ddl )和数据操作语言( dml )语句,然后返回输出参数。
Using a . net framework data provider , you can execute stored procedures or data definition language statements for example , create table and alter column to perform schema manipulation on a database or catalog 使用. net framework数据提供程序,您可以执行存储过程或数据定义语言语句(如create table和alter column )来对数据库或编录执行架构处理。
The initial , partial restore sequence restores the files in the primary filegroup and perhaps other files to any point in time that is supported by the recovery model , and then brings the database online 在事务复制中,一个命令由一个transact - sql数据操作语言( dml )语句或一个数据定义语言( ddl )语句组成。命令首先存储在分发数据库中,然后传递到订阅服务器。
If you try to deploy native xml web services on an instance of sql server that does not meet this operating system requirement and does not support http . sys , data definition language operations will fail and no native listening will occur 如果试图在不满足此操作系统要求且不支持http . sys的sql server实例上部署本机xml web服务,数据定义语言操作将失败,并且不会发生本机侦听。
With transaction isolation , when a row versioning - based isolation level is enabled , the process in which the database engine maintains versions of data rows affected by data manipulation language execution 数据定义语言( ddl ) ( data definition language ( ddl ) )一种语言,通常是数据库管理系统的一部分,用于定义数据库的所有特性和属性,尤其是行布局、列定义、键列(有时是键控方法) 、文件位置和存储策略。
Integration services now includes a number of tasks that perform business intelligence operations , such as processing analytic objects , running scripts written in the analysis services data definition language , and executing data mining prediction queries Integration services现在提供很多执行商业智能操作的任务,如处理分析对象、运行以analysis services数据定义语言( ddl )编写的脚本以及执行数据挖掘预测查询。
For example , most errors from a data definition language statement such as create table , or most errors that occur when set xact abort is set to on , terminate the transaction outside a try block but make a transaction uncommittable inside a try block 例如,数据定义语言( ddl )语句(如create table )中的大多数错误或set xact _ abort设置为on时出现的大多数错误都在try块外终止事务,而在try块内显示为事务无法提交。
Object names used with all data definition language statements such as create , alter , or drop statements , dbcc statements , execute and dynamic sql statements should be qualified with the name of the object schema if other users are to use the stored procedure 如果有其他用户要使用存储过程,则用于所有数据定义语言( ddl )语句(例如create 、 alter或drop语句, dbcc语句, execute和动态sql语句)的对象名应该用该对象架构的名称来限定。
Instead , when a transaction begins and commands are performed in query language , data manipulation language , or data definition language within the transaction , sql server mobile locks whatever resources are required to help protect the resources at the isolation level that you want 相反,当事务开始并在事务内以查询语言、数据操作语言( dml )或数据定义语言( ddl )执行命令时, sql server mobile会锁定任何所需的资源以帮助保护所需隔离级别的资源。