What are two valid ways to query a table on a Linked Server?
- Using OPENQUERY:
SELECT * FROM OpenQuery(XPODASERVER, 'SELECT * FROM XPODA_CLIENT_USERS')2. Using four-part naming:SELECT * FROM XPODASERVER.XPODA.dbo.XPODA_CLIENT_USERS
AI Assistant
SELECT * FROM OpenQuery(XPODASERVER, 'SELECT * FROM XPODA_CLIENT_USERS') 2. Using four-part naming: SELECT * FROM XPODASERVER.XPODA.dbo.XPODA_CLIENT_USERS