DEFAULT

  • PChiragS

    SSCarpal Tunnel

    Points: 4965

    Nice Question..

  • tom.w.brannon

    Hall of Fame

    Points: 3956

    New to this so I added NOT NULL to the end of the ALTER statement and found that the previously inserted rows has isDeleted set to 0. I wanted to confirm that it would not generate an error.

  • Primo Dang

    SSCrazy

    Points: 2643

    George M Parker (10/18/2013)


    Ed Wagner (10/18/2013)


    tabinsc (10/18/2013)


    Victor Kirkpatrick (10/18/2013)


    Might be an easy one, but I learned something: the WITH VALUES clause. Thanks.

    Same here

    Same for me.

    Same here, wasn't familiar with the WITH VALUES clause.

    +1

  • Mark Cowne

    One Orange Chip

    Points: 26762

    George M Parker (10/18/2013)


    Ed Wagner (10/18/2013)


    tabinsc (10/18/2013)


    Victor Kirkpatrick (10/18/2013)


    Might be an easy one, but I learned something: the WITH VALUES clause. Thanks.

    Same here

    Same for me.

    Same here, wasn't familiar with the WITH VALUES clause.

    +1

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537
  • samp.silvercreek

    Ten Centuries

    Points: 1160

    Victor Kirkpatrick (10/18/2013)


    Might be an easy one, but I learned something: the WITH VALUES clause. Thanks.

    +1:-)

  • Revenant

    SSC-Forever

    Points: 42467

    Really nice one for the end of the work-week. Thanks, Umer!

  • Hany Helmy

    SSChampion

    Points: 13488

    Good question & nice idea, thanx.

  • SqlMel

    SSCrazy

    Points: 2891

    My first thought was "this is WAY too easy".

    Then again, I did not know about the "With values" clause so I learned something.

    Thanks

    ---------------
    Mel. 😎

  • jagdish.175

    SSC Enthusiast

    Points: 148

    Nice Question

  • webrunner

    SSC-Dedicated

    Points: 30400

    Great question. I didn't know about the WITH VALUES option before this.

    Thanks,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • jfgoude

    SSCrazy

    Points: 2586

    oooppsss did not look at the null value, answered to fast !

  • twin.devil

    SSC-Insane

    Points: 22208

    happens 😉

Viewing 12 posts - 16 through 27 (of 27 total)

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