OPENDATASOURCE问题急!!!!!!!!!

[wyb0026]

Set @Sql='Data Source=mypc;User ID=sa;Password=123'
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
@Sql
).[pub].dbo.A
left join B on A.job_id =B.job_id

报错
服务器: 消息 170，级别 15，状态 1，过程 SP_IMPUTDATA，行 22
Line 22: Incorrect syntax near '@Sql'.

[子陌红尘]

declare @Sql varchar(1000)
set @Sql='Data Source=mypc;User ID=sa;Password=123'

exec('SELECT *
FROM OPENDATASOURCE(
''SQLOLEDB'',
'''+@Sql+'''
).[pub].dbo.A
left join B on A.job_id =B.job_id')

[samfeng_2003]

呵呵！老麻客遇新问题！:)

[wyb0026]

我傻了，今天脑袋不好用。