说明:hzyl_bc_zyfymxb 表里 detailid列为主键,不允许重复;zyh为主键,允许重复,现在想给一个住院号里多增加点detailid不同的本表记录,但是detailid相同zhy的不允许重复,所以用到自增列:
第一步:
SELECT top 2000 195900000054763001 as zyh
,detailid=IDENTITY(int,1000,1)
,[sfrq]
,[xmlx]
,[xmyybm]
,[xmzxbm]
,[xmmc]
,[xmgg]
,[xmdw]
,[xmdj]
,[sl]
,[je]
,[zf_je]
,[operid]
,[isUpload]
,[hylx] into #temp
FROM [hzyl_qzj0710].[dbo].[hzyl_bc_zyfymxb];
第二步:
INSERT INTO [hzyl_qzj0710].[dbo].[hzyl_bc_zyfymxb]
([zyh]
,[detailid]
,[sfrq]
,[xmlx]
,[xmyybm]
,[xmzxbm]
,[xmmc]
,[xmgg]
,[xmdw]
,[xmdj]
,[sl]
,[je]
,[zf_je]
,[operid]
,[isUpload]
,[hylx])
select * from #temp