Skip to content
Advertisement

Tag: multiple-databases

SQL – Select from Multiple databases

I have 10 databases all in the same instance and schema with identical tables. Looking to create a SELECT query which can use a variable of the database names and return all of the records into a single dataset. I’ve been looking around and put the following together as a test (the real select statement is much larger with multiple

Advertisement