--可以,两个单引号代表一个,如
select a.* FROM OPENROWSET('MSDAORA','XXX';'USERID';PWD,
'select * from TABLE1 where COLUMNNAME=''2006-08-28 10:00:00''')
AS a
select a.* FROM OPENROWSET('MSDAORA','XXX';'USERID';PWD,
'select * from TABLE1 where COLUMNNAME=''2006-08-28 10:00:00''')
AS a
'select * from TABLE1 where COLUMNNAME=to_date("2006-08-28 10:00:00","yyyy-mm-dd hh24:mi:ss")')
AS a
当改为这样是,在SQL查询分析器里有如下错误:
服务器: 消息 7321,级别 16,状态 2,行 1
准备对 OLE DB 提供程序 'MSDAORA' 执行查询时出错。
[OLE/DB provider returned message: ORA-00904: invalid column name
]
OLE DB 错误跟踪[OLE/DB Provider 'MSDAORA' ICommandPrepare::Prepare returned 0x80040e14]。
请问如何解决,急啊!
-----------------------------------------------------------------
不知道是没见过,还是错误的!
'select * from TABLE1 where COLUMNNAME=convert(char,''2006-08-28 10:00:00'',121)')
AS a