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, 1709🔥, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...