Remember
Register
1
new
Chill
new
Puzzles
new
GK
new
Sports
new
Business
Home
Questions
MCQs
Unanswered
Tags
Users
Ask a Question
Write Article
Articles
Connect to us
Related Articles
Displaying the Row Number in a SELECT Query with SQL Server 2005
how to insert multiple records in a single query?
+3
votes
372
views
how to insert multiple records in a single query?
sql
sql server
posted
May 15, 2015
by
Muskan
Share this question
Your comment on this post:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
1 Answer
+1
vote
Best answer
INSERT INTO
(col1, col2,...., coln) SELECT col1, col2,...., coln FROM ;
answer
May 15, 2015
by
Arun Gowda
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Your answer
Preview
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Similar Questions
+6
votes
How to change multiple column datatype in SQL Server single query.
+1
vote
Is there a way to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field?
+1
vote
Update a single table based on data from multiple tables SQL Server 2005,2008
+1
vote
MangoDB: How to insert multiple documents within a collection using a single query ?
+5
votes
How to create a CSV file of any table by sql query in sql server?
...