Que: Which of the following query combines data from more than one SQL Server instance?

a. USE SCRATCHGOSELECT TOP 1000 *FROM REMOTE.Scratch.dbo.Table1 T1INNER JOIN REMOTE.Scratch.dbo.Table2 T2ON T1.ID= T2.ID
b. USE SCRATCHGOSELECT *FROM dbo.Table1 T1INNER JOIN REMOTE.Scratch.dbo.Table2 T2ON T1.ID= T2.IDWHERE T1.GUIDSTR < '001'
c. USE SCRATCHGOSELECT TOP 500 *FROM REMOTE.Scratch.dbo.Table1 T1OUTER JOIN REMOTE.Scratch.dbo.Table2 T2ON T1.ID= T2.ID
d. None of the mentioned
Answer: USE SCRATCHGOSELECT *FROM dbo.Table1 T1INNER JOIN REMOTE.Scratch.dbo.Table2 T2ON T1.ID= T2.IDWHERE T1.GUIDSTR < '001'

Leave a Comment