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 :: mysql biginteger size 
Sql :: oracle select row max date 
Sql :: show table mysql 
Sql :: How to insert Arabic characters into SQL database 
Sql :: 2nd max salary query in sql 
Sql :: mysql disable logging 
Sql :: t-sql random number for each row 
Sql :: print hello world in sql 
Sql :: sql power function 
Sql :: sql string function update replace 
Sql :: grant all privileges database postgres to user 
Sql :: find mysql password 
Sql :: postgres sum when 
Sql :: ignore case in string sql 
Sql :: checking data type in sql server 
Sql :: group by clause with join in sql 
Sql :: mysql timestamp vs datetime 
Sql :: change schema in sql server 
Sql :: smallint sql 
Sql :: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 
Sql :: SQL COUNT() with GROUP BY 
Sql :: set mysql password 
Sql :: mysql remove database 
Sql :: remove root password mysql 
Sql :: SELECT DISTINCT on one column, with multiple columns returned, ms access query 
Sql :: mysql default uuid 
Sql :: mysql group by 
Sql :: copy table in sql 
Sql :: sqlite update query python 
Sql :: sql count() 
ADD CONTENT
Topic
Content
Source link
Name
3+7 =