Viewing 15 posts - 51,766 through 51,780 (of 59,072 total)
shamas saeed (3/14/2008)
Yes You can do with as all above says or use ## to use it in procedure
Global temp tables are a bad idea... if more than one instance...
March 14, 2008 at 12:53 pm
John Rowan (3/14/2008)
I just wanted to thank you all for your military service.
Awesome, John. Thank you, Sir!
March 14, 2008 at 9:51 am
Chrissy (3/14/2008)
I am very much a newbie, and I just wanted to say this forum has actually given me confidence to start training as a SQL DBA in my...
March 14, 2008 at 9:50 am
Anders Bendix Nielsen (3/14/2008)
That is simply one of the best articles on RBAR I have ever seen!Excellent!! 🙂
Thanks for the great feedback, Anders.
March 14, 2008 at 8:10 am
ALZDBA (3/14/2008)
If our dev's would only apply the basic rules and also try to write their
code at least in two different ways,...
March 14, 2008 at 8:09 am
Nick M. (3/14/2008)
The links to UPDATE are to the UPDATE() function, not the UPDATE statement syntax, which is 1 line above in the index. 🙂
Thanks for pointing that out, Nick....
March 14, 2008 at 8:01 am
David McKinney (3/14/2008)
Very good article.I just think RBAR would catch on more, if it were pronounced AR-BAR. (Sorry 😉 )
Maybe "our Bar" would work even better 😀
March 14, 2008 at 7:55 am
Zarko Jovanovic (3/14/2008)
what about this:update table1
set table1.column1 = #table.column1, table1.column2 = #table.column2
from table1, #table
where table1.pk=#table.pk
That's fine because the table being updated is in the FROM clause and is properly joined......
March 14, 2008 at 7:54 am
I believe you also need to do a DBCC FREEPROCCACHE before a DBCC DROPCLEANBUFFERS if you trully want to make sure the execution plan is cleared.
March 13, 2008 at 11:49 pm
Dang... I thought for sure it stood for "Customers Test Problems" 😛
March 13, 2008 at 11:44 pm
The reason you're getting the file does not exist error is probably because of permissions. What ever user you SQL Services start up as, must be able to "see"...
March 13, 2008 at 11:24 pm
Why not? VARCHAR MAX holds 2 billion + characters...
March 13, 2008 at 10:44 pm
Indexed multi-table view... multi-table SELECT... which one will you call UPDATEable? Neither in all likely hood. An update would have to be something separate... paging isn't used to...
March 13, 2008 at 10:37 pm
That would be correct (about the XP's in 2k). Didn't mention those because didn't think they would apply here.
March 13, 2008 at 10:34 pm
Viewing 15 posts - 51,766 through 51,780 (of 59,072 total)