Collections:
Inserting Multiple Rows with One INSERT Statement in SQL Server
How To Insert Multiple Rows with One INSERT Statement in SQL Server?
✍: FYIcenter.com
If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives you a good example:
INSERT INTO fyi_links SELECT id+500, REVERSE(url), notes, counts, created FROM fyi_links GO (3 row(s) affected) SELECT * FROM fyi_links GO id url notes counts created 101 dev.fyicenter.com NULL 0 2006-04-30 102 dba.fyicenter.com NULL 0 2007-05-19 103 sqa.fyicenter.com NULL NULL 2007-05-19 601 moc.retneciyf.ved NULL 0 2006-04-30 602 moc.retneciyf.abd NULL 0 2007-05-19 603 moc.retneciyf.aqs NULL NULL 2007-05-19
As you can see, "INSERT INTO ... SELECT ..." is powerful statement. you can use it build up data in tables quickly.
⇒ Updating Values with UPDATE Statements in SQL Server
⇐ Duplicate Key Error on Primary Key Columns in SQL Server
2016-11-02, 1936🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...