27,580
社区成员
发帖
与我相关
我的任务
分享
contents time ip
410048 2015-11-01 00:00:03.900 /122.96.46.175:61337
410048 2015-11-01 00:00:23.950 /122.96.46.175:61337
410048 2015-11-01 00:00:52.323 /122.96.46.175:61337
410048 2015-11-01 00:01:12.357 /122.96.46.175:61337
410048 2015-11-01 00:01:32.450 /122.96.46.175:61337
410048 2015-11-01 00:01:52.497 /122.96.46.175:61337
410048 2015-11-01 00:02:12.603 /122.96.46.175:61337
410048 2015-11-01 00:02:32.637 /122.96.46.175:61337
410048 2015-11-01 00:02:52.723 /122.96.46.175:61337
410048 2015-11-01 00:03:12.773 /122.96.46.175:61337
410048 2015-11-01 00:03:32.850 /122.96.46.175:61337
contents time ip
410048 2015-11-01 00:00:03.900 /122.96.46.175:61337
410048 2015-11-01 00:03:12.773 /122.96.46.175:61337
410048 2015-11-01 00:06:16.580 /122.96.46.175:61337
410066 2015-11-01 00:00:55.260 /122.96.46.165:61337
410066 2015-11-01 00:03:59.317 /122.96.46.165:61337
--0. 准备测试表及测试数据
IF OBJECT_ID('dbo.T1','U') IS NOT NULL
DROP TABLE dbo.T1
GO
IF OBJECT_ID('dbo.T1_old','U') IS NOT NULL
DROP TABLE dbo.T1_old
GO
CREATE TABLE dbo.T1(
id INT,
d DATETIME,
CONSTRAINT PK_T1 PRIMARY KEY(
id ASC
)
)
GO
INSERT INTO T1(ID,d) VALUES(1, DATEADD(mm, -30, GETDATE()))
INSERT INTO T1(ID,d) VALUES(2, GETDATE())
GO
--1. 原表改名
EXEC sp_rename 'T1', 'T1_old'
GO
--2. 原表中的部分数据插入到新表; 旧表中删除新表有的数据
SELECT * INTO T1 FROM T1_old WHERE d>DATEADD(mm, -30, GETDATE())
DELETE FROM T1_old FROM T1 WHERE T1_old.id=t1.id
GO
--3. 新表加上主键约束
ALTER TABLE T1 ADD CONSTRAINT PK_T1_new PRIMARY KEY (id)
--4. 查看旧表与新表
SELECT * FROM T1
SELECT * FROM T1_old