查询问题，马上解贴！不够再加

[niaoren]

CREATE PROCEDURE [dbo].[获取设备参数值]
@tableName nvarchar(100),
@id nvarchar(500)
AS
declare @s varchar(1000)
set @s = ''
select @s=@s+rtrim(name) + ',' from syscolumns where id = object_id(@tableName) and name not in
('备用代码','备注','批准是否通过')
order by colid
set @s=left(@s,len(@s)-1)
exec('select ' + @s + ' from ' + @tableName + ' where equipID in (' + @id + ')')
我现在要加一个联接，就是要通过设备equipID 号联接另一个表（equip 它的主键是equipID)的5个字段，

[pengdali]

CREATE PROCEDURE [dbo].[获取设备参数值]
@tableName nvarchar(100),
@id nvarchar(500)
AS
declare @s varchar(1000)
set @s = ''
select @s=@s+''''+rtrim(name) + ''',' from syscolumns where id = object_id(@tableName) and name not in
('备用代码','备注','批准是否通过')
order by colid

set @s=left(@s,len(@s)-1)

exec('select ' + @s + ' from ' + @tableName + ' where equipID in (' + @id + ')')

[pengdali]

''转义为'如：

select '''','''''',char(39)

[niaoren]

还是不懂，请指点

[pengdali]

select 'asfas' 显示字符

改成 exec 你怎么写?

[pengdali]

exec('select ''asfas''')

[niaoren]

我不懂你的意思！

[niaoren]

我是问怎么做那个联接

[pengdali]

o

CREATE PROCEDURE [dbo].[获取设备参数值]
@tableName nvarchar(100),
@id nvarchar(500)
AS
declare @s varchar(1000)
set @s = ''
select @s=@s+'a.'+rtrim(name) + ',' from syscolumns where id = object_id(@tableName) and name not in
('备用代码','备注','批准是否通过')
order by colid
set @s=left(@s,len(@s)-1)
exec('select ' + @s + ',b.[5个字段] from ' + @tableName + ' a,另一个表 b where equipID in (' + @id + ') and a.equip=b.equip')

[niaoren]

谢谢你！我还想请教一下，像这样的查询会影响速度吗？因为“另一个表”会特别的大

[niaoren]

好像还有点小问题，@S 里的字段怎么解决，b.@S好像不行啊

[niaoren]

已经解决了