我想将连接远程查询的一个结果 写入临时表,应该怎么写?select * into #ls1 from
(select * from opendatasource(
'sqloledb',
'data source=192.168.252.204;User ID=sa;Password=caption.'
).hysuper.dbo.bbssum)我这样写不成功,提示我第5行)有语法错误. 麻烦大家看看.
(select * from opendatasource(
'sqloledb',
'data source=192.168.252.204;User ID=sa;Password=caption.'
).hysuper.dbo.bbssum)我这样写不成功,提示我第5行)有语法错误. 麻烦大家看看.
(select * from opendatasource(
'sqloledb',
'data source=192.168.252.204;User ID=sa;Password=caption.'
).hysuper.dbo.bbssum) t加个别名
(select * from opendatasource(
'sqloledb',
'data source=192.168.252.204;User ID=sa;Password=caption.'
).hysuper.dbo.bbssum) AS T
select * from opendatasource(
'sqloledb',
'data source=192.168.252.204;User ID=sa;Password=caption.'
).hysuper.dbo.bbssumtry