Transact-SQL 语法约定 语法 适用于 SQL Server、Azure SQL 数据库和 Azure SQL 托管实例的语法 syntaxsql 复制 CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON ( column [ ASC | DESC ] [ ,...n ] ) [ INCLUDE ( column_name [ ,...n ] ) ] [ WHERE <filter_predica...
Transact-SQL 語法慣例 語法 syntaxsql 複製 CREATE SPATIAL INDEX index_name ON ( spatial_column_name ) { <geometry_tessellation> | <geography_tessellation> } [ ON { filegroup_name | "default" } ] [;] ::= { database_name.schema_name.table_name | sc...
such as Microsoft® SQL Server™, that does not already have an index. You do not need permission or access to the remote server to create a pseudo index, and the remote database is unaware of and unaffected by the pseudo index. You use the same syntax for both linked and...
such as Microsoft® SQL Server™, that does not already have an index. You do not need permission or access to the remote server to create a pseudo index, and the remote database is unaware of and unaffected by the pseudo index. You use the same syntax for both linked and...
If the view definition contains a GROUP BY clause, the key of the unique clustered index can reference only the columns specified in the GROUP BY clause. The SELECT statement in the view definition must not contain the following Transact-SQL syntax: Expand table Transact-SQL functionPossible al...
If the view definition contains a GROUP BY clause, the key of the unique clustered index can reference only the columns specified in the GROUP BY clause. The SELECT statement in the view definition must not contain the following Transact-SQL syntax: Expand table Transact-SQL functionPossible al...
For more information about the syntax conventions, seeTransact-SQL syntax conventions. Select a product In the following row, select the product name you're interested in, and only that product's information is displayed. * SQL Server *
Transact-SQL 语法约定语法syntaxsql 复制 CREATE SPATIAL INDEX index_name ON ( spatial_column_name ) { <geometry_tessellation> | <geography_tessellation> } [ ON { filegroup_name | "default" } ] [;] ::= { database_name.schema_name.table_name | schema_name.table_name | tabl...
In this article Syntax Arguments See Also New: 14 April 2006Creates an index on a specified table. An index can be created before there is data in the table..SyntaxCopy CREATE [UNIQUE] [NONCLUSTERED] INDEX index_name ON table_name (column_name [ASC|DESC][,…n]) WITH (STATISTICS_...
Transact-SQL 语法约定 SQL Server 语法 syntaxsql -- SQL Server Syntax-- Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger)CREATE[ORALTER]TRIGGER[schema_name. ]trigger_nameON{ table | view } [WITH<dml_trigger_option>[ ,...n ] ] {FOR|AFTER|INSTEADOF}...