sql如何读变量呢 mssql2005

[样样红]

select ROW_NUMBER () over(order by id desc) as RowsIndex,* from OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'sa','exec newssystem.dbo.procNewsSelectAll') 这个是读取存储过程的语句，我想把存储过程名称写成变量，但是一直报错，内容如下，先谢谢大家，这个该如何写


declare @sql char(50)
set @sql='newssystem.dbo.procNewsSelectAll'
select ROW_NUMBER () over(order by id desc) as RowsIndex,* from OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'sa','exec '+ @sql+''')'







select ROW_NUMBER () over(order by id desc) as RowsIndex,* from OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'sa','exec newssystem.dbo.procNewsSelectAll')

[CaRrot_Love]

没有这样写过，参数引号拼接的问题吧参考

[样样红]

declare @sql char(1500) declare @sql1 char(1500) set @sql='newssystem.dbo.procNewsSelectAll '')' set @sql1= 'select ROW_NUMBER () over(order by id desc) as RowsIndex,* from OPENROWSET(''SQLOLEDB'',''127.0.0.1'';''sa'';''sa'',''exec '+ @sql print @sql1 exec @sql1 改完也不行