delete from purchasemaster
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select * from [date#txt]') as ddate)提示:
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'DG-SDK-IT1' is unavailable.
請問那里出了錯誤????
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select * from [date#txt]') as ddate)提示:
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'DG-SDK-IT1' is unavailable.
請問那里出了錯誤????
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select * from [date#txt]') as ddate)l0001 2006-03-21 00:00:00.000 safsa sa NULL
L0002 2006-04-15 00:00:00.000 dd dd NULL
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select * from [date#txt]') as ddate)
l00012006-03-21 00:00:00.000safsasaNULL
L00022006-04-15 00:00:00.000ddddNULL --TXT文件里存在多列.
把*换了select * from purchasemaster
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select [时间字段列] from [date#txt]') as ddate)
select * from purchasemaster
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select * from [date#txt]') as ddate)
是可以查詢到記錄但是我現在是要刪除這些記錄,用
delete from purchasemaster
where purchasedate>(select F1 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;DATABASE=c:\aa\','select * from [date#txt]') as ddate)提示:
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'DG-SDK-IT1' is unavailable.
請問那里出了錯誤????
where purchasedate>@date