T SQL

  • Comments posted to this topic are about the item T SQL

    [font="Verdana"] There is no Wrong time to do a Right thing πŸ™‚ [/font]

  • Good question πŸ™‚

    M&M

  • I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    πŸ™‚

  • rhythmk (7/9/2012)


    I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:

    +1

  • Easy point, thx!

  • This was removed by the editor as SPAM

  • Easy one πŸ™‚

  • Nice one,thank you for the point.

    β€œWhen I hear somebody sigh, β€˜Life is hard,’ I am always tempted to ask, β€˜Compared to what?’” - Sydney Harris

  • Pretty confident the answer would be an error, but I had to go and test it because the question specified SQL 2012 and I thought they might have changed it! πŸ˜€

  • kupy (7/10/2012)


    rhythmk (7/9/2012)


    I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:

    +1

    +2 !

  • Toreador (7/10/2012)


    kupy (7/10/2012)


    rhythmk (7/9/2012)


    I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:

    +1

    +2 !

    +3...

    What you don't know won't hurt you but what you know will make you plan to know better
  • I thought this must be a trick question, but no...

  • Well this has been the definition from 6.5. Actually I was confused by the fact of SQL 2012.

    But eventually the definition does not change at all.

    +1.

  • paul.knibbs (7/10/2012)


    Pretty confident the answer would be an error, but I had to go and test it because the question specified SQL 2012 and I thought they might have changed it! πŸ˜€

    +1

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Thanks for the question.

    KR,

    Iulian

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

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