阅读背景:

使用链接数据库服务器将参数从当前数据库传递到链接数据库服

来源:互联网 

I want to write an select query using OPENQUERY in SQL server where i have to select the records from linked server but in where clause i have to compare the dates but the date should be from a table present in current DB not in linked server DB. For example: Select * from OPENQUERY(Linked_Server,'select * from db.table_name where Edate>(select edate from CurrentDB)')I want to write an select query using OPENQUERY




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: