SqlServer 获取特定表中有哪些字段(或者说哪些列),并且按照查表时列名的顺序显示
--直接把该条语句的AAA_AAA_TRXTEST1改成自己的表就行了 select s.name from syscolumns s where s.id = object_id('AAA_AAA_TRXTEST1') order by s.colid;
--直接把该条语句的AAA_AAA_TRXTEST1改成自己的表就行了 select s.name from syscolumns s where s.id = object_id('AAA_AAA_TRXTEST1') order by s.colid;