Multiple Inserts

Question

Multiple Inserts

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

tilew-948340 Hall of Fame Points: 3431 More actions · Answer 1

I was so sure I knew the right answers that I would have bet on it! Good thing I did not as I got it wrong :blush:

I have the excuse that I never had to put many rows with only one query (use application reading excel files and for loop), so never had to search to do it.

So much to learn, but this one, I know how to do it now

Thanks!

AMOLDAROTE Grasshopper Points: 13 More actions · Answer 2

INSERT TABLE1 (COL1,COL2) VALUES ('A', 'AA'), ('B','BB'),('C','CC')

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Easy and straight-forward question.

Thank you.

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Jagadish Kumar Punnapu SSChasing Mays Points: 645 More actions · Answer 4

Jagadish Kumar Punnapu

SSChasing Mays

Points: 645

January 24, 2012 at 12:06 am

#1437488

Good question... Thanks...

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Woot woot easy one 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Koen Verbeeck (1/24/2012)
Woot woot easy one 😀

Apparently not terribly easy - 36% of answers to date were wrong. [Which rather surprises me.] 🙁

Tom

Neeraj Prasad Sharma Ten Centuries Points: 1315 More actions · Answer 7

That was easy.

Neeraj Prasad Sharma
Sql Server Tutorials