lyfz_repos/经典版源码/document/数据库维护脚本/设置dindanjd表联合主键.sql

-- ============================================= 
-- 程序编写： Jeff
-- 版    本:  V 1.0
-- 建立日期： 2015-05-18
-- 功能说明： 设置dindanjd表联合主键;
-- 备    注： 

-- 修改日期：
-- 修改说明：

-- ============================================= 

use [ddf]

-- 1.设置id不为null;
alter table dindanjd alter column [id] nvarchar(50) not null

-- 2.设置name不为null; 
alter table dindanjd alter column [name] nvarchar(50) not null

-- 3.设置联合主键;
alter table dindanjd add constraint PK_dindanjd primary key([id],[name]) 

-- 执行1或2时出错;
-- 按提示,把该记录删除;
delete from dindanjd where id is null or id = ''
delete from dindanjd where name is null or [name] = ''

-- 执行3时出错,一般为id和name出现重复记录,按条件删除时间比较早的记录即可(只能手动删除,暂时无法自动删除重复数据);
-- 示例:提示20131017-001有重复,select出结果,根据具体情况修改where条件的值来删除多余的记录;
select * from dindanjd where id = '20140824-001'
delete from dindanjd where id = '20140824-001' and [name] = '默认景点' and [time] in ('11:31:20','11:27:47')
delete from dindanjd where id = '20140824-001' and [name] = '内景大西街店A棚' and [date] in ('2014-08-24')


--select distinct * into dindanjd_backup from dindanjd 
--select identity(int,1,1) as autoid, id, [name] into dindanjd_backup from dindanjd
--select * into dindanjd_backup from dindanjd
select id,name into dindanjd_backup from dindanjd
select distinct * into dindanjd_backup2 from dindanjd_backup

select COUNT(*) from dindanjd_backup
select COUNT(*) from dindanjd
select COUNT(*) from dindanjd_backup2

drop table dindanjd_backup2
drop table dindanjd_backup