Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to insert multiple values

Author  Topic 

immad
Posting Yak Master

230 Posts

Posted - 2014-04-14 : 07:00:33
hi
this is my data

AM1WSJZ1241
AM1WLSU7162
AM1SXBI5100
AM1TWXX0477
AM1MSMQ6167
AM1WRQP1810
AM1HNME1411

i want a query to insert a data in table
thanks for the help

immad uddin ahmed

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-04-14 : 08:32:01
Two typical approaches:

INSERT ... VALUES
(...row 1 data...),
(...row 2 data...),
...

INSERT ...
SELECT (...row 1 data...)
UNION
SELECT (...row 2 data...)
UNION
SELECT ...
Go to Top of Page
   

- Advertisement -