INSERT INTO #TMP1
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.11;User ID=sa;Password=sa
).hksales.dbo.rep_staffsales '2005','2008','',''
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.11;User ID=sa;Password=sa
).hksales.dbo.rep_staffsales '2005','2008','',''
Server: Msg 156, Level 15, State 1, Line 23
Incorrect syntax near the keyword 'FROM'.
请问有详细的解决方案吗?
EXEC OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.11;User ID=sa;Password=sa
).hksales.dbo.rep_staffsales '2005','2008','',''
把select后面的内容用一个括号括上~