Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql server select another database

SELECT * FROM [DATABASE].dbo.[TABLE]
Comment

select from another database

You have to select for shema name.

// Show Schema Names

show schemas;
Comment

PREVIOUS NEXT
Code Example
Sql :: mariadb select limit offset 
Sql :: a query to determine the version of a database 
Sql :: A bad way of running a SQL query in JDBC 
Sql :: mysql export data with a where clause 
Sql :: implizite joins sql 
Sql :: proc sql not in working 
Sql :: how to connect .sql data set to powerbi 
Sql :: jdbc:sqlserver://localhost;username=MyUsername;password={pass";{}}word}; 
Sql :: ring MySQL get the inserted row id 
Sql :: liquibase create table example 
Sql :: Every Derived yable must have its own alias 
Sql :: alter table add column integer default 0 
Sql :: oracle tablespace owners 
Sql :: Show mysql account privilleges 
Sql :: how to make oppointment table in database 
Sql :: remove record from table sql 
Sql :: How To Execute SQL Select Statements 
Sql :: faster mysql imports 
Sql :: BSD sed: extra characters at the end of d command 
Sql :: pl sql constraint user function 
Sql :: composite primary key sql 
Sql :: bitmap join index 
Sql :: selects all the columns from the sailors table 
Sql :: month() in sql 
Sql :: date functions 
Sql :: postgresql 
Sql :: update having mysql 
Sql :: dbms transaction tutorialspoint 
Sql :: firebase sql 
Sql :: There are multiple records in a table and some are duplicates. Which command will fetch only one copy of the duplicate records? Pick ONE option SELECT DISTINCT SELECT UNIQUE SELECT DIFFERENT All of the above 
ADD CONTENT
Topic
Content
Source link
Name
8+6 =