Inserts

  • demonfox

    SSCertifiable

    Points: 6289

    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:

  • Lokesh Vij

    SSChampion

    Points: 10836

    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: 3158

    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

    Good Question. Tricky as well..

  • tommyh

    SSCertifiable

    Points: 6252

    :angry:

    <censured>

    /T

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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: 5524

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

  • okbangas

    SSChampion

    Points: 11773

    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

    +1

    [font="Verdana"]Regards,
    Rals
    [/font].
  • paul.knibbs

    SSCoach

    Points: 15270

    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... ๐Ÿ™‚

  • anthony.green

    SSC Guru

    Points: 112481

    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: 5136

    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

    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

    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

    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.

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

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