sql
-
BKPF表查询优化——加索引
1234567891011121314151617select belnr xblnr from bkpfwhere bukrs eq '1000'and gjahr eq '2018'and monat eq '05'and blart eq 'RV'and BSTAT in ('','A','B','D','L','M','S','V','W','Z','C','O'). -
zsql_free – OpenSQL Editor for SAP
在SAP中写SQL测试语句的一个工具。The missing piece from the ABAP development workbench. https://sta-tech…
-
HANA数据库查询重复行
1234--查询重复行select "CustID"from "DW2"."Customer"where "CustID" in(select "CustID" from "DW2"."Customer" group by "CustID" having count(1)>=2) -
从A库表重复更新B库表的两种思路
123456789101112131415161718192021222324252627282930从A库表重复更新B库表的两种思路思路1:每次清空B库表中的数据再insert;思路2:每次都drop掉表再insert;由于业务需求频繁变化,A库中的表可能会经常调整结构,因此我们采用每次都drop掉表再insert的方式、减少工作量!----------思路1举例:--先清理数据再insert的方式(请勿删除,以备后用!)--清空数据truncate table "DW2"."ZCRM_CUSTOMER" ;truncate table "DW2"."ZCRM_MATERIAL" ;truncate table "DW2"."ZCRM_ORDER" ;--插入数据insert into "DW2"."ZCRM_CUSTOMER" select * from "DW1"."ZCRM_CUSTOMER";insert into "DW2"."ZCRM_MATERIAL" select * from "DW1"."ZCRM_MATERIAL";insert into "DW2"."ZCRM_ORDER" select * from "DW1"."ZCRM_ORDER";----------思路2举例:--每次都drop掉表再insert的方式--drop表drop table "DW2"."ZCRM_CUSTOMER" ;drop table "DW2"."ZCRM_MATERIAL" ;drop table "DW2"."ZCRM_ORDER" ;--create table select from...create table "DW2"."ZCRM_CUSTOMER" as ( SELECT * FROM "DW1"."ZCRM_CUSTOMER") ;create table "DW2"."ZCRM_MATERIAL" as ( SELECT * FROM "DW1"."ZCRM_MATERIAL") ;create table "DW2"."ZCRM_ORDER" as ( SELECT * FROM "DW1"."ZCRM_ORDER") ; -
PostgreSQL 与 SQL Server 的数据类型映射
数据类型在做数据库迁移的时候要用到,不同数据库间的数据类型不尽相同,因此迁移的时候一定要注意数据类型转换,否则会造成数据数据精度丢失、数据截断、乱码等异常问题。 注意:Postgr…