跨数据库查询语句 OPENQUERY 带参数||查ORACLE数据库||时间转换

---------------------------------------OPENQUERY------------------------------------------------------------------------

普通：写的时候一定要注意里面没有冒号;

SELECT * FROM OPENQUERY([10.11.7.112],'select to_date(''2012-06-18 00:00:00'',''yyyy-mm-dd hh24:mi:ss'')  from dual')

带参数的话，网上看到的example：
亲测可用

DECLARE @Sql VARCHAR(1000)
DECLARE @organizationID VARCHAR(10)
SELECT @organizationID = (SELECT ORGANIZATION_ID FROM MYORGS WHERE ORGANIZATION_NAME = 'MMT')
SET @Sql = 'SELECT * from tableName where organization_id ='+@organizationID 
SET @Sql = 'SELECT * FROM OPENQUERY(LinkedServerName, ''' + REPLACE(@Sql, '''', '''''') + ''')'
EXEC(@Sql)