Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Multiple Inserts Expand / Collapse
Author
Message
Posted Tuesday, January 17, 2012 9:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 3,795, Visits: 1,139
I agree with cengland0 about portability. You never know where your code will end up running, even if it is a secured ("closed"?) environment. As a former Tech Support Analyst, we got several headaches when new versions of SQL Server were released because of code deprecation and incompatibility, so I wave the "As Standard As Possible" flag.

Cheers,


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.
Post #1237320
Posted Tuesday, January 17, 2012 10:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks Steve.
Post #1237379
Posted Tuesday, January 17, 2012 11:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:26 AM
Points: 1,803, Visits: 2,168
Toreador (1/17/2012)
Hugo Kornelis (1/17/2012)
A good question, and it's hard to see how anbody could contest the correct answer.


How long before someone complains that the correct answer is an error message saying there's no such table as my table


Not me, but about those column names ... certainly it's not good design practice to use such generic column names.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1237406
Posted Tuesday, January 17, 2012 2:07 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 10:26 AM
Points: 11,194, Visits: 11,136
Hugo Kornelis (1/17/2012)
EDIT: Removed the color tag after a few failed attempts to use it - I hope just using bold text emphasises the changes sufficiently.

Like this...? (the stupid trick here is to put double-quotes around the hex colour value *and* the leading # sign. Awesome.)

HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo
HugoHugoHugoHugoHugoHugo




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1237523
Posted Tuesday, January 17, 2012 4:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:13 PM
Points: 5,967, Visits: 8,221
SQL Kiwi (1/17/2012)
Like this...? (the stupid trick here is to put double-quotes around the hex colour value *and* the leading # sign. Awesome.)

Thanks, Paul. I missed the double-quotes.
I have now edited my post to show the missing bits in red.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1237577
Posted Tuesday, January 17, 2012 5:02 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:37 PM
Points: 589, Visits: 2,437
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
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!
Post #1237582
Posted Wednesday, January 18, 2012 5:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 29, 2012 1:40 PM
Points: 1, Visits: 26
INSERT TABLE1 (COL1,COL2) VALUES ('A', 'AA'), ('B','BB'),('C','CC')
Post #1237873
Posted Wednesday, January 18, 2012 11:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Easy and straight-forward question.
Thank you.




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1238450
Posted Tuesday, January 24, 2012 12:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 17, 2014 9:44 AM
Points: 127, Visits: 105
Good question... Thanks...
Post #1240642
Posted Tuesday, January 24, 2012 3:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:38 AM
Points: 13,555, Visits: 10,432
Woot woot easy one



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1240707
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse