|
Posted by Fran on 04/10/07 15:15
(SQL 2005)
I'm looking to create a stored procedure to first "select name from
sys.databases where name like '%site'" then pass each name to the
following using some kind of loop "USE @name select name from
sys.tables where type = 'U'"
I tried a while statement, but the master sys.databases recordset
doesn't change..
It's the loop I can't get to work.
Any help is greatly appreciated!
Navigation:
[Reply to this message]
|