31
12/11
SQL取回表中字段
取回表中字段: declare @listvarchar(1000), @sql nvarchar(1000) select @list=@list+','+b.name from sysobjects a,syscolumns b wherea.id=b.id and a.name='表A' set @sql='select '+right(@list,len(@list)-1)+'from 表A' exec (@sql)