November 22, 2001 at 4:04 pm
Take a look at these two articles:
http://www.sqlservercentral.com/columnists/bknight/sp_msforeachtable.asp
http://www.sqlservercentral.com/columnists/bknight/sp_msforeachdb.asp
Andy
November 22, 2001 at 5:03 pm
I'm very against the sp_foreach... SPs.
They use cursors (something I never allow) and I feel are more difficult to use than a temp table - and also lock you in to row by row processing (I get a lot of people comming with problems using those SPs).
OK I know most people think this is an irrationally severe stance but it teaches developers to at least think about the relational structure in the first instance.
P.S. I have only ever coded one cursor (except on forums like this to show how they can be used and why not - but I don't compile them) and that was many years ago - and again to show why it wasn't a good replacement for the set based code.
Just caught someone who wrote a stored procedure to encapsulate a cursor accessing a table - this could be replaced by one line of sql (I mean one line on a screen) - he refuses to rewrite but then I don't spend much time at that company.
Cursors never.
DTS - only when needed and never to control.
November 30, 2001 at 8:24 pm
Dear Nigel
I've put your code into admin database.
Can i run your code every month ?
Dear
Huil0n6
November 30, 2001 at 8:54 pm
You should be able to run Nigel's code without an issue. I agree with Nigel and hate to use cursors, but if I have to, I'd rather decide how it is used.
Steve Jones
Viewing 4 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply