请问这样的sql语句怎么写存储过程？

[kzccomputer]

select * into temp from openrowset( 'SQLOLEDB', 'SHANGYIN-AD52B3\SQLEXPRESS2005'; 'sa'; '2010',Chbase.dbo.Chinese_Area)

请问上面的服务器、用户名、密码通过输入参数传入怎么写？

注意关键是上面单引号我不知道怎么处理！！！！！！

[-晴天]

create procedure getlikedata(@server nvarchar(20),@username nvarchar(20),@passwd nvarchar(20))
declare @sql nvarchar(max)
set @sql='select * from openrowset(''sqloledb'','''+@server+''';'''+@username+''';'''+@passwd+''',Chbase.dbo.Chinese_Area)'
exec(@sql)
end
go
exec getlikedata 'SHANGYIN-AD52B3\SQLEXPRESS2005','sa','2010'

[--小F--]

转义一下 '''表示单引号

[-晴天]

create procedure getlikedata(@server nvarchar(20),@username nvarchar(20),@passwd nvarchar(20))
as
begin
declare @sql nvarchar(max)
set @sql='select * from openrowset(''sqloledb'','''+@server+''';'''+@username+''';'''+@passwd+''',Chbase.dbo.Chinese_Area)'
exec(@sql)
end
go
exec getlikedata 'SHANGYIN-AD52B3\SQLEXPRESS2005','sa','2010'
go
drop procedure getlikedata

[kzccomputer]

但是运行通不过