How to use SQL server foreach loop?
In powershell I use foreach to run a function through a list of targets. I was wondering that if there is any thing similar to foreach in sql, so I can run the same query through multiple DBs I chose and save the results to one csv file?
You can do this in T-SQL, PowerShell is still viable and potentially a lot easier, especially when you leverage dbatools. You can use Get-DbaDatabase to not only get the databases but also easily filter out problematic ones you probably don't want to execute against (system dbs, offline dbs, etc): Get-DbaDatabase -Status 'Normal' -ExcludeSystem -OnlyAccessible And then run Invoke-DbaQuery to run your command against each of the databases returned.