CREATE PROCEDURE up_1 @parm varchar(100) --传递参数需要检索表名 ASdeclare @sql varchar(8000)set @sql='select 'select top 1 @sql=@sql+fie from a where tabl=@parmset @sql=@sql+ ' from ' + @parm exec(@sql)
表名、字段等是变量必须用动态SQL
declare @sql varchar(8000) select @sql='select '+fie+ ' from ' +tab1 from a where id=你要的记录ID值 exec(@sql)
up_1 @parm varchar(100) --传递参数需要检索表名
ASdeclare @sql varchar(8000)set @sql='select 'select top 1 @sql=@sql+fie from a where tabl=@parmset @sql=@sql+ ' from ' + @parm
exec(@sql)
select @sql='select '+fie+ ' from ' +tab1 from a where id=你要的记录ID值
exec(@sql)