Wednesday, March 7, 2012

Query to another DB

Hi,
Is anyway to Query to another DB?
I wrote the SQL Syntax on DB A and want to Query the data from DB B.
How can I implement this function?
Thanks for help!
Angiangi
SELECT <columns> FROM DataBase.dbo.Tablename WHERE.......
"angi" <angi@.news.microsoft.com> wrote in message
news:ueozMgIXGHA.1204@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Is anyway to Query to another DB?
> I wrote the SQL Syntax on DB A and want to Query the data from DB B.
> How can I implement this function?
> Thanks for help!
> Angi
>|||Thanks, Uri!
"Uri Dimant" <urid@.iscar.co.il> glsD:uGv$wvIXGHA.4620@.TK2MSFTNGP04.phx.gbl...[vbco
l=seagreen]
> angi
> SELECT <columns> FROM DataBase.dbo.Tablename WHERE.......
>
> "angi" <angi@.news.microsoft.com> wrote in message
> news:ueozMgIXGHA.1204@.TK2MSFTNGP04.phx.gbl...
>[/vbcol]

No comments:

Post a Comment