① select count(1) from syscolumns where id=object_id('tablename')
② select count(*) from syscolumns where id=object_id('tablename')
③ select max(colid) from syscolumns where id=object_id('tablename')
转载于:https://www.cnblogs.com/oceans106/p/5177929.html
相关资源：JAVA上百实例源码以及开源项目
