Can the two libraries create views

wxmzhht

I want to query some data from multiple tables in two databases, can I create a view? How to create it?

arbuliyerlu

sure
Select * From Library A.dbo. Table A, Library B.dbo. Table B...

忧伤蓝调

Theoretically possible
But there are not many cases like this, right?

saintfrosty

Yes, you can reference other databases by connecting to the server or using the RowSet function. You can even associate a SQL Server database with an Oracle database and use a SQL statement to query.

But this is not a database forum. Starting from the application, it emphasizes the ORM method programming search and avoids the use of non-portable SQL statements. Sometimes it is also a principle that should be appreciated.

digimoon

I heard that it can work across servers.

saintfrosty

Connect server --> Link server