گاهی نیاز داریم که اطلاعات خود را از دو یا چند پایگاه داده بخوانیم که این پایگاه داده ها می توانند در سرور جاری یا سرورهای متفاوت باشند.
روش کلی بدین صورت است :
.... FROM ServerName.DatabaseName.OwnerName.ObjectName ...
مثال :
SELECT * FROM Server1.Accounting.dbo.Customers WHERE CustomerID = 12345 SELECT * FROM Accounting.dbo.Customers WHERE CustomerID = 12345
Thanks for the inishgt. It brings light into the dark!
Just cause it’s simple doesn’t mean it’s not super hlpeful.
Way to use the internet to help people solve prolbems!
I found just what I was needed, and it was entreatining!
What I find so interesintg is you could never find this anywhere else.
The honesty of your posting sinhes through
You’ve ipmrsesed us all with that posting!
Hey, that post leaves me feeling fooilsh. Kudos to you!
That hits the treagt perfectly. Thanks!
Your potsing lays bare the truth
You’ve impsresed us all with that posting!
Ah yes, nicely put, eevyrnoe.
Big help, big help. And superltavie news of course.
Your post capurtes the issue perfectly!