Post reply

DEFAULT

  • October 18, 2013 at 7:50 am

    #1659720

    Nice Question..

  • October 18, 2013 at 8:59 am

    #1659749

    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.

  • October 18, 2013 at 9:25 am

    #1659764

    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

  • October 18, 2013 at 9:36 am

    #1659771

    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

  • October 18, 2013 at 12:20 pm

    #1659816

    Victor Kirkpatrick (10/18/2013)

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

    +1:-)

  • October 18, 2013 at 12:26 pm

    #1659821

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

  • October 19, 2013 at 2:41 am

    #1659896

    Good question & nice idea, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • October 19, 2013 at 7:49 am

    #1659915

    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. 😎

  • October 21, 2013 at 2:09 am

    #1660048

    Nice Question

  • October 23, 2013 at 1:43 pm

    #1661090

    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

  • November 5, 2013 at 5:03 am

    #1664099

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

  • November 6, 2013 at 3:23 am

    #1664366

    happens 😉

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

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