declare @a varchar(100)
set @a='select '
select @a=@a+name+',' from syscolumns where object_name(id)='tb_student'
select @
结果:
select student_address,student_age,student_dempt,student_major,
student_name,student_no,student_sex,student_year,
把表tb_student的字段名全部放在变量@a中,但是这时排序不是按照当初设计表的时候的顺序
要是 我这么写:
declare @a varchar(100)
set @a='select '
select @a=@a+name+',' from syscolumns where object_name(id)='tb_student'
order by colid
select @a
结果:select student_address,只有设计表时最后一列的字段名
怎么样才能把全部的字段都显示出来 并且按照设计表时排列????
不要用 select * from tb_student
|