Is either the OPENQUERY or OPENROWSET function. For more information about updatable views, see CREATE VIEW (Transact-SQL). For example, an INSERT into a multi-table view must use a column_list that references only columns from one base table. The view referenced by table_or_view_name must be updatable and reference exactly one base table in the FROM clause of the view. Is the name of the table or view that is to receive the data.Ī table variable, within its scope, can be used as a table source in an INSERT statement. Is the name of the schema to which the table or view belongs. When server_name is specified with OPENDATASOURCE, database_name and schema_name may not apply to all data sources and is subject to the capabilities of the OLE DB provider that accesses the remote object. When server_name is specified as a linked server, database_name and schema_name are required. server_name can be specified as a linked server name, or by using the OPENDATASOURCE function. Is the name of the linked server on which the table or view is located. Is an optional keyword that can be used between INSERT and the target table.Īpplies to: SQL Server 2008 (10.0.x) and later. For more information, see TOP (Transact-SQL). expression can be either a number or a percent of the rows. Specifies the number or percent of random rows that will be inserted. For more information, see WITH common_table_expression (Transact-SQL). The result set is derived from a SELECT statement. Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation. ![]() Transact-SQL syntax conventions Syntax - Syntax for SQL Server and Azure SQL Database
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |