T-SQL sp_msforeachdb example

for-each-db-example.sql

EXEC sp_msforeachdb '

if ''?'' LIKE ''CMS[_]%'' begin
	print ''?'';

	use [?]

	select setting as TransactionGateway, ''?'' as [Database]
	from dbo.Setting with(nolock)
	where Id = ''TransactionGateway''
END
'