You can also set the collation order by using Transact-SQL.
也可以使用 Transact-SQL 设置排序规则顺序。
You typically use this stored procedure to open a new event batch so you can submit individual events using Transact-SQL.
通常使用该存储过程打开一个新事件批次,以便使用 Transact-SQL 提交单个事件。
When you define an event class, you can define one or more chronicle tables by using Transact-SQL.
定义事件类时,可使用 Transact-SQL 定义一个或多个历史记录表。
This table contains filestream data that cannot be partitioned using this wizard. For more information on partitioning tables using Transact-SQL, see Books Online.
You can use the Link Table Wizard to conveniently link to one or more tables in an external OLE DB data source. The Link Table Wizard creates a view for each table based on either a Microsoft SQL Server Linked Server or a Transact SQL OLE DB ad hoc connection. A Linked Server provides the most functionality, including data updates if the OLE DB data source allows, and permanently stores the data source connection information in the SQL Server option is dimmed if you aren't a member of either the sysadmin or setupadmin roles. A link to an OLE DB data source using a Transact SQL function creates an ad hoc read-only connection to the external data source.
"链接表向导"可以使您方便地链接到一个外部 OLE DB 数据源中的一个或多个表上。"链接表向导"为每个表创建一个视图,这个视图可以是基于 SQL Server 链接服务器的,也可以是一个事务处理 SQL 的 OLE DB 临时连接。 链接服务器提供了强大的功能: 如果数据源允许,它可以更新您的数据;还可以将数据源连接信息永久地存储在 SQL Server 数据库中。但如果您不是 sysadmin 或 setupadmin 角色,这些选项将被隐去。 一个到 OLE DB 数据源的链接使用一个事务处理 SQL 函数创建一个到外部数据源的临时只读连接。
Separate individual Transact-SQL statements by using the batch separator.
使用批处理分隔符来分隔各条 Transact-SQL 语句。
Dynamic management views can be referenced in Transact-SQL statements by using two-part, three-part, or four-part names.
通过使用两部分、三部分或四部分所组成的名称,可在Transact-SQL语句中引用动态管理视图。
Changing the path or file name in the Restore As column is equivalent to using the MOVE option in a Transact-SQL RESTORE statement.
Runs a Transact-SQL query against a target instance of SQL Server. The On Demand condition is the only supported evaluation mode for ExecuteSql. Only one table column can be specified in a SELECT statement; more than one column will throw an exception. A SELECT statement can use the following variables, which will be substituted at run time by using ADO.NET parameter substitution: @ObjectName - corresponds to the name field in sys.objects. The variable will be replaced with the name of the current object. @SchemaName - corresponds to the name field in sys.schemas. The variable will be replaced with the schema for the current object if the current object belongs to a schema.
Os exemplos servem apenas como ajuda na tradução da palavra ou da expressão procurada. Eles não são selecionados ou validados por nós e podem conter linguagem inapropriada. Pedimos que reporte exemplos que devem ser modificados ou que não devem ser exibidos. As traduções potencialmente sensivéis, impróprias ou coloquiais geralmente são marcadas em vermelho ou em laranja.