datamigrate.txt

来自「地址档案管理系统」· 文本 代码 · 共 55 行

--select bdate, len(bdate) as l from zhcg where len(bdate)<>10 order by l

/*
update zhcg
set gdate=left(gdate,5)+'01.'
where len(gdate)=8 and ltrim(rtrim(substring(gdate,6,2)))=''
*/
/*
update zhcg
set gdate=gdate+'01'
where len(gdate)=8
*/

--update zhcg set bzrq=cast(bdate as datetime), gdrq=cast(gdate as datetime)
/*
  update 
zhcg 
  set 
zwbt=ltrim(rtrim(isnull(ctitle1,'')))+ltrim(rtrim(isnull(ctitle2,''))),
ywbt=ltrim(rtrim(isnull(etitle1,'')))+ltrim(rtrim(isnull(etitle2,'')))
*/

SELECT QKH, CXXH, CLFF, gdate, ft
FROM DK31B
ORDER BY QKH, CXXH, CLFF
-------------------------------------------
SELECT QKH, CXXH, CLFF, COUNT(GDATE) AS cs
FROM DK31B
GROUP BY QKH, CXXH, CLFF
ORDER BY QKH, CXXH, CLFF
-------------------------------------------
/*
SELECT * from dzcsda_a order by xh
SELECT * from dzcsda_b order by xh
*/
select XH as XH字段, Count(a.xh) as 重复次数
from dzcsda_a as a
group by a.xh
having count(a.xh)>1
order by xh
---------------------------
select * 
from dzcsda_a 
where xh in (
select XH as XH字段
from dzcsda_a as a
group by a.xh
having count(a.xh)>1
)
order by xh

报表--地震测线特殊处理登记表
SELECT [DK31A].[GDATE], [DK31A].[CLFF], [DK31A].[CXXH], [DK31A].[LINENO], [DK31A].[PAO1], [DK31A].[PAO2], [DK31A].[CTITLE], [DK31A].[ETITLE], [DK31A].[FT], [DK31A].[BZ], [DK31A].[BDATE], [DK31A].[LADDR], [DK31A].[DTDH], [DK31A].[DADDR], [DK31A].[FZ], [DK31A].[QKH]
FROM DK31A
WHERE [DK31A].[QKH]=[区块号];