Inserts

Question

Post reply

Inserts

demonfox

SSCertifiable

Points: 6289
More actions
August 22, 2012 at 8:28 pm

#280137

Comments posted to this topic are about the item Inserts
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Viewing 15 posts - 1 through 15 (of 62 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

I knew there is a limit of 1000 records. But got it wrong 🙁

Overlooked the question: Inserts start from 0 that makes the first statement to exceed this limit as well.

Nevermind, a good question indeed 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

MissTippsInOz Hall of Fame Points: 3160 More actions · Answer 2

Lokesh Vij (8/22/2012)
I knew there is a limit of 1000 records. But got it wrong 🙁
Overlooked the question: Inserts start from 0 that makes the first statement to exceed this limit as well.
Nevermind, a good question indeed 🙂

Snap!! I'd look at lot smarter if I read the question once in a while 😉

Jamsheer Ten Centuries Points: 1136 More actions · Answer 3

Jamsheer

Ten Centuries

Points: 1136

August 22, 2012 at 11:01 pm

#1529031

Good Question. Tricky as well..

tommyh SSCertifiable Points: 6302 More actions · Answer 4

tommyh

SSCertifiable

Points: 6302

August 22, 2012 at 11:30 pm

#1529037

:angry:

/T

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

Dammit! Moar coffee!

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

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 6

Where are the variable definitions? I can see only the inserts (Chrome) :w00t:

okbangas SSChampion Points: 11773 More actions · Answer 7

Good question, as others I overlooked the zero and hence got it wrong.

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]

ralm Hall of Fame Points: 3156 More actions · Answer 8

ralm

Hall of Fame

Points: 3156

August 23, 2012 at 1:32 am

#1529069

+1

^{[font="Verdana"]Regards,
Rals[/font].}

paul.knibbs SSCoach Points: 15320 More actions · Answer 9

I didn't overlook the zero on the first one, but that's maybe because I've programmed in both C and BASIC and you soon learn to notice things like that after finding off-by-one errors all over the place in your code... 🙂

Ant-Green SSC Guru Points: 113445 More actions · Answer 10

More coffee needed, I didn't read the question right, thought it was inserting many columns not 1 column, so the limit would of been 4096 so selected S,E,E doh to early on this grimm Thursday morning.

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 11

Knew about the 1000 limit but missed the start from 0!!! Doh... definitely wont try this again without coffee!

Very sneaky question, but a good reminder...

Agree that we do need variable or table declaration though!

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 12

Great question although I got it wrong by missing the (0)

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 13

okbangas (8/23/2012)
Good question, as others I overlooked the zero and hence got it wrong.

Nice question!

I joined your club 🙂

Regards

IgorMi

Igor Micev,My blog: www.igormicev.com

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 14

Good question, I thought there would be a limit but didn't know what it was. Guessed 1000 would be okay (overlooked the zero!), 8096 too many for a #table, and 65k fine for a permanent table - SES.

Never mind - I learned something new!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.