Udawwka ona machanla
same server eke thiyena database 2ka tables dekak join karala select query ekak gahanne kohomada?
same server eke thiyena database 2ka tables dekak join karala select query ekak gahanne kohomada?
Latest ads
-
Gemini AI PRO 18 months Offer- Hawaka
- Updated:
-
koko account
- DasunEranga
- Updated:
-
koko account
- DasunEranga
- Updated:
SQL Help
- Thread starter wiskoththa
- Start date
SQL server or MySQL ?
For SQL Server, use full qualified object names.
[DbName].[schema name (default 'dbo')]. [TableName].[Column name]
Ex.
Select * from
DbA.dbo.Table1 A
inner join
DbB.dbo.Table2 B
on A.Col1 = B.Col1
where A.Col2 >0
You can even join two databases on two different servers by adding as a linked server.
For SQL Server, use full qualified object names.
[DbName].[schema name (default 'dbo')]. [TableName].[Column name]
Ex.
Select * from
DbA.dbo.Table1 A
inner join
DbB.dbo.Table2 B
on A.Col1 = B.Col1
where A.Col2 >0
You can even join two databases on two different servers by adding as a linked server.
Last edited:
SELECT *
INTO #Reciever
FROM OPENROWSET('SQLNCLI',
'DRIVER={SQL Server};SERVER=ServerName;UID=userID;PWD=password',
'SELECT *
FROM dbName.dbo.receiver')
WHERE min_price >= @min_price
AND max_price <= @max_price
*i didn't seen "same server"
you can use tables within same server different Database like this
select * from B2BSystem.dbo.[Level1]
B2BSystem = database name
dbo = schema
Level1 = table
Last edited:
