sql server select another database
SELECT * FROM [DATABASE].dbo.[TABLE]
select from another database
You have to select for shema name. // Show Schema Names show schemas;
Source: dataedo.com
SELECT * FROM [DATABASE].dbo.[TABLE]
You have to select for shema name. // Show Schema Names show schemas;