导出数据库所有行数小于1万行的表的数据
SQLServer
1.查出所有表
use [DBName]; select * from sysobjects where xtype='U';2.将表名粘出来,用文本编辑取,列选择等操作编辑成如下格式
use [DBName]; select * from ( select 'Tab1Name' as name,count(*) as num from Tab1Name union all select 'Tab2Name' as name,count(*) as num from Tab2Name union all select 'Tab3Name' as name,count(*) as num from Tab3Name ) taba where num>100003.导出数据时,不选这些表
相关阅读
评论:
↓ 广告开始-头部带绿为生活 ↓
↑ 广告结束-尾部支持多点击 ↑