Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Looping Through Dbases on an instance

Status
Not open for further replies.
PJSWEAT

PJSWEAT

Programmer
Feb 3, 2003
82
US

I need to loop thru all databases on an instance of SQL Server, If tblOrder exists in the database I want to extract the number of rows bases on the datecreated field into another table.

Does anybody have a recommendation on how to handle?

Thanks!
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
351
Volvere
V
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
215
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
483
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to make pivot for features dynamically based on feature name and feature value ?
Replies
1
Views
117
TamarGranor
TamarGranor
iambob
  • Locked
  • Question
Show all Customers through SQL 1
Replies
8
Views
118
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top