SELECT d.name tablename, a.colorder serial,a.name colname
FROM syscolumns a inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
where d.NAME='TABLE1' --your table's name
order by a.id,a.colorder
FROM syscolumns a inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
where d.NAME='TABLE1' --your table's name
order by a.id,a.colorder
SELECT d.name tablename, a.colorder serial,a.name colname
FROM syscolumns a inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
where d.NAME='TABLE1' --your table's name
order by a.id,a.colorder然后:
ALTER TABLE TABLE1 ADD column_1 VARCHAR(20) NULL
急,后天就要交东西了,谢谢了!!
记录集是否应该重新绑定呢,表还是原来的表,只不过是添加了字段而已嘛