Viewing 15 posts - 2,251 through 2,265 (of 8,416 total)
Thanks Wayne, Jason, Gianluca, and Roy 🙂
December 21, 2010 at 10:16 pm
stephan.koeppen (12/21/2010)
Thats the table I have. What i want to do is update the diff column with id 2.
Assuming you want to update all rows, not just the one with...
December 21, 2010 at 2:52 am
vinothraj (12/21/2010)
hmm.. Yep, but we may lose continuity.. so we have to keep long thread some time.. 😀
Not that long. Be reasonable.
December 21, 2010 at 2:40 am
vinothraj (12/21/2010)
I dont know why its gets differs.. attached screenshot.. by the by, my machine is i5
Do us all a favour and learn how to cut the quoted text down...
December 21, 2010 at 2:21 am
Gianluca Sartori (12/21/2010)
I don't want to look like you-know-who, but you really have to fix your design.
Celko often makes good points, it's just the delivery that is sometimes a bit...
December 21, 2010 at 2:01 am
Gianluca Sartori (12/21/2010)
Conor Cunningham has a nice blog post on Runtime Constants:
He has covered the subject (fairly lightly) more than once:
http://www.sqlskills.com/BLOGS/CONOR/post/Wrapping-my-head-around-RAND()-in-SQL-Server.aspx
http://www.sqlskills.com/blogs/conor/post/RAND()-and-other-runtime-constant-functions-redux.aspx
Paul
December 21, 2010 at 1:55 am
There's not much new at all in SP4, compared to the previously released cumulative updates for SP3.
Are people excited about this primarily because Service Packs are perceived as being better...
December 21, 2010 at 1:24 am
Jeff Moden (12/21/2010)
Agh. My bad. I didn't read that they were trying to do it on an UPDATE or anything other than a SELECT for that matter.
No worries...
December 21, 2010 at 1:05 am
rob mcnicol (12/21/2010)
choice names for the studentschur!
Best comment so far! :laugh:
December 21, 2010 at 12:34 am
Yes, GetDate() and CURRENT_TIMESTAMP are both implemented as the intrinsic function getdate, so at executin time there is absolutely no difference whatsoever. Not even a little bit.
Whether the function...
December 21, 2010 at 12:32 am
I was hoping Denali (SQL11) would be 64-bit only, but at least they have clarified its target usage by removing 32-bit AWE, so 32-bit OS servers will only support up...
December 20, 2010 at 11:56 pm
Wildcat (12/20/2010)
How could a NOLOCK hint to the target table on the DELETE or UPDATE statement? Make no sense to me.
Precisely. It's just an oversight in the parser:
-- Error...
December 20, 2010 at 11:35 pm
Gianluca Sartori (12/20/2010)
I couldn't load Grant's blog today, it seemed to be down, but now it loads and also I got a mail from him.
I can't believe...
December 20, 2010 at 9:15 am
mtassin (12/20/2010)
December 20, 2010 at 9:11 am
Viewing 15 posts - 2,251 through 2,265 (of 8,416 total)