![]() 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. 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 Adds one or more rows to a table or a view in SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |