读书人

请教下列怎样传送参数呢?多谢

发布时间: 2011-12-30 23:30:45 作者: rapoo

请问下列怎样传送参数呢?谢谢
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 ' ' '

读书人网 >SQL Server

热点推荐