October 18, 2013 at 7:50 am
Nice Question..
October 18, 2013 at 8:59 am
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
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
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/61537October 18, 2013 at 12:20 pm
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
Really nice one for the end of the work-week. Thanks, Umer!
October 19, 2013 at 2:41 am
Good question & nice idea, thanx.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
October 19, 2013 at 7:49 am
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
Nice Question
October 23, 2013 at 1:43 pm
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
oooppsss did not look at the null value, answered to fast !
November 6, 2013 at 3:23 am
happens 😉
Viewing 12 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply