Database Access

Question

Hi all, I want code about how to access table values from more than one database in SQL and how we display that values?

Answer 1

Use the fully qualified name for your objects.

Select *
From DatabaseName.SchemaOwner.ObjectName