摘要:
首先我们的基础的数据如下:USE tempdb;GOIF OBJECT_ID('dbo.T1') IS NOT NULL DROP TABLE dbo.T1GOCREATE TABLE dbo.T1(col1 INT NOT NULL PRIMARY KEY);INSERT INTO dbo.T1(col1) VALUES(1);INSERT INTO dbo.T1(col1) VALUES(2);INSERT INTO dbo.T1(col1) VALUES(3);INSERT INTO dbo.T1(col1) VALUES(100);INSERT INTO dbo.T1( 阅读全文