create procedure Select_A_Name
@A varchar(32),
@Name varchar(32)asbegin
declare @sql varchar(255)
select @sql = ' select ' + Name + ' from ' + A
exec @sql
end
@A varchar(32),
@Name varchar(32)asbegin
declare @sql varchar(255)
select @sql = ' select ' + Name + ' from ' + A
exec @sql
end
SET @STR='GREATE TABEL '+(SELECT TOP 1 NAME FROM A)+'........'
EXEC(@STR)
@tablename nvarchar(50),
@Fields nvarchar(100)
as
declare @sql nvarchar(500)
select @sql = ' select ' + @fields + ' from ' + @tablename
exec( @sql)
谢谢!再现等待中……