请问下列怎样传送参数呢?谢谢
declare @ipaddress char(30)
set @ipaddress= '127.0.0.1 '
select * into A from OPENDATASOURCE(
'SQLOLEDB ',
'Data Source=127.0.0.1;User ID=sa;Password=sa '
).SERVERDB.dbo.MFG where dbo.MFG.DATETIMES > = '2007-3-9 '
请问如何用@ipaddress,去做data source的参数呢?
thanks
------解决方案--------------------declare @ipaddress char(30)
set @ipaddress= '127.0.0.1 '
declare @s varchar(8000)
set @s= 'select * into A from OPENDATASOURCE(
' 'SQLOLEDB ' ',
' 'Data Source= ' ' '+@ipaddress+ ';User ID=sa;Password=sa ' '
).SERVERDB.dbo.MFG where dbo.MFG.DATETIMES > = ' '2007-3-9 ' ' '