这些东西不是二维表,不然可以
insert into tb
DBCC SHOWCONTIG('person.person')
来获取,你看看WINFORM有没有什么控件可以整个贴下去
DBCC SHOWCONTIG('person.person')/*
DBCC SHOWCONTIG scanning 'Person' table...
Table: 'Person' (1509580416); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 3807
- Extents Scanned..............................: 477
- Extent Switches..............................: 476
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.79% [476:477]
- Logical Scan Fragmentation ..................: 0.03%
- Extent Scan Fragmentation ...................: 5.03%
- Avg. Bytes Free per Page.....................: 1156.3
- Avg. Page Density (full).....................: 85.71%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
*/
insert into tb
DBCC SHOWCONTIG('person.person')
来获取,你看看WINFORM有没有什么控件可以整个贴下去
DBCC SHOWCONTIG('person.person')/*
DBCC SHOWCONTIG scanning 'Person' table...
Table: 'Person' (1509580416); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 3807
- Extents Scanned..............................: 477
- Extent Switches..............................: 476
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.79% [476:477]
- Logical Scan Fragmentation ..................: 0.03%
- Extent Scan Fragmentation ...................: 5.03%
- Avg. Bytes Free per Page.....................: 1156.3
- Avg. Page Density (full).....................: 85.71%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
*/
解决方案 »
- BCP 导出包含列名
- 统计各城市数量
- 触发器:两个表有三个字段相同,其中一个插入数据时,需要更新另外一个对应的三个字段
- 保留最后一条数据,这个该怎么实现?
- 如何把几条类似查询语句合并为一条SQL语句?
- 关于事物复制!!
- OUTPUT怎么样处理NTEXT数据类型
- stoping ...sql server,sql無法重新啟動了
- 如何实现连接两个数据库中的表格?急!
- 如何从win98+sql7的数据库中把数据倒到win2000p+sql2000中,二者异构,要求实时更新目标库
- win8能安装Microsoft SQL Server 2005 Express Edition 版本吗?
- 想确认一个UPDATE性能问题
/*
ObjectName ObjectId IndexName IndexId Level Pages Rows MinimumRecordSize MaximumRecordSize AverageRecordSize ForwardedRecords Extents ExtentSwitches AverageFreeBytes AveragePageDensity ScanDensity BestCount ActualCount LogicalFragmentation ExtentFragmentation
a 2111346586 0 0 1 10 61 61 61 0 1 0 7466 7.75883370397826 100 1 1 0 0
*/
insert into 新建表
DBCC ShowContig(a) WITH TABLEresults这样数据就进入那个新建表,你前端操作这个表即可