=================================
重新初始化自动编号
truncate table tableName
DBCC checkident(tableName ,reseed,1)
===========================
将查询出的结果插入另一张表
insert into tb_columnInfo(tableID,columnName,columnComment)
(select ID,tb_column,comment from tb_column_control)