truncate table
--删除单个站点的相关数据【只删除数据，不删除基本信息】
--总表
DELETE FROM  [In_Port_Log] where Hardware_Id=''
DELETE FROM  [In_Port_LogError] where Hardware_Id=''
--降雨
DELETE FROM  [HY_OBP_G] where STCD = '' --降雨记录表
DELETE FROM  [ST_PPTN_R] where STCD = '' --降雨处理表
DELETE FROM  [HY_DP_C] where STCD = ''  --降雨日记录
DELETE FROM  [HY_MTP_E] where STCD = ''  --降雨月纪录
DELETE FROM  [HY_YRP_F] where STCD = ''  --降雨年纪录
DELETE FROM  [Ep_YQ_JC] where STCD = ''  --预警
DELETE FROM  [LH_P_R] where STCD = ''  --实时表
DELETE FROM  [LH_P_DAY] where STCD = ''  --降雨统计表：日表
DELETE FROM  [LH_P_MONTH] where STCD = ''  --降雨统计表：月表
--流量
DELETE FROM  [ST_RIVER_R] where STCD = ''  --河道处理表
DELETE FROM  [HY_DQ_C] where STCD = ''  --流量日记录
DELETE FROM  [HY_MTQ_E] where STCD = ''  --流量月纪录
DELETE FROM  [HY_YRQ_F] where STCD = ''  --流量年纪录
DELETE FROM  [LH_Q_DAY] where STCD = ''  --河道统计表：日表
DELETE FROM  [LH_Q_MONTH] where STCD = ''  --河道统计表：月表
DELETE FROM  [LH_Q_DAY_MinMaxAvg] where STCD = ''  --河道统计表：最大最小值表
--库容
DELETE FROM  [ST_RSVR_R] where STCD = ''  --库容处理表
DELETE FROM  [HY_DV_C] where STCD = ''  --库容日记录
DELETE FROM  [HY_MTV_E] where STCD = ''  --库容月纪录
DELETE FROM  [HY_YRV_F] where STCD = ''  --库容年纪录
DELETE FROM  [LH_V_DAY] where STCD = ''  --库容统计表：日表
DELETE FROM  [LH_V_MONTH] where STCD = ''  --库容统计表：月表
DELETE FROM  [LH_V_DAY_MinMaxAvg] where STCD = ''  --库容统计表：最大最小值表
--水位
DELETE FROM  [HY_DZ_C] where STCD = ''  --水位日记录
DELETE FROM  [HY_MTZ_E] where STCD = ''  --水位月纪录
DELETE FROM  [HY_YRZ_F] where STCD = ''  --水位年纪录
DELETE FROM  [HY_OBZ_G] where STCD = ''  --水位记录表
DELETE FROM  [LH_Z_DAY_JD] where STCD = ''  --水位统计表：日表
DELETE FROM  [LH_Z_MONTH_JD] where STCD = ''  --水位统计表：月表
DELETE FROM  [LH_Z_DAY_JD_MinMaxAvg] where STCD = ''  --水位统计表：最大最小值表
DELETE FROM  [LH_Z_DAY_XD] where STCD = ''  --水位统计表：日表
DELETE FROM  [LH_Z_MONTH_XD] where STCD = ''  --水位统计表：月表
DELETE FROM  [LH_Z_DAY_XD_MinMaxAvg] where STCD = ''  --水位统计表：最大最小值表
DELETE FROM  [Ep_SQ_JC] where STCD = ''  --预警
DELETE FROM  [LH_Z_R] where STCD = ''  --实时表
-
-删除多个站点的相关数据【只删除数据，不删除基本信息】
--总表
DELETE FROM  [In_Port_Log] where Hardware_Id in ('','')
DELETE FROM  [In_Port_LogError] where Hardware_Idin ('','')
--降雨
DELETE FROM  [HY_OBP_G] where STCD in ('','') --降雨记录表
DELETE FROM  [ST_PPTN_R] where STCD in ('','') --降雨处理表
DELETE FROM  [HY_DP_C] where STCD in ('','')  --降雨日记录
DELETE FROM  [HY_MTP_E] where STCD in ('','')  --降雨月纪录
DELETE FROM  [HY_YRP_F] where STCD in ('','')  --降雨年纪录
DELETE FROM  [Ep_YQ_JC] where STCD in ('','')  --预警
DELETE FROM  [LH_P_R] where STCD in ('','')  --实时表
DELETE FROM  [LH_P_DAY] where STCD in ('','')  --降雨统计表：日表
DELETE FROM  [LH_P_MONTH] where STCD in ('','')  --降雨统计表：月表
--流量
DELETE FROM  [ST_RIVER_R] where STCD in ('','')  --河道处理表
DELETE FROM  [HY_DQ_C] where STCD in ('','')  --流量日记录
DELETE FROM  [HY_MTQ_E] where STCD in ('','')  --流量月纪录
DELETE FROM  [HY_YRQ_F] where STCD in ('','')  --流量年纪录
DELETE FROM  [LH_Q_DAY] where STCD in ('','')  --河道统计表：日表
DELETE FROM  [LH_Q_MONTH] where STCD in ('','')  --河道统计表：月表
DELETE FROM  [LH_Q_DAY_MinMaxAvg] where STCD in ('','')  --河道统计表：最大最小值表
-
-库容
DELETE FROM  [ST_RSVR_R] where STCD in ('','')  --库容处理表
DELETE FROM  [HY_DV_C] where STCD in ('','')  --库容日记录
DELETE FROM  [HY_MTV_E] where STCD in ('','')  --库容月纪录
DELETE FROM  [HY_YRV_F] where STCD in ('','')  --库容年纪录
DELETE FROM  [LH_V_DAY] where STCD in ('','')  --库容统计表：日表
DELETE FROM  [LH_V_MONTH] where STCD in ('','')  --库容统计表：月表
DELETE FROM  [LH_V_DAY_MinMaxAvg] where STCD in ('','')  --库容统计表：最大最小值表
truncate删除数据
--水位
DELETE FROM  [HY_DZ_C] where STCD in ('','')  --水位日记录
DELETE FROM  [HY_MTZ_E] where STCD in ('','')  --水位月纪录
DELETE FROM  [HY_YRZ_F] where STCD in ('','')  --水位年纪录
DELETE FROM  [HY_OBZ_G] where STCD in ('','')  --水位记录表
DELETE FROM  [LH_Z_DAY_JD] where STCD in ('','')  --水位统计表：日表
DELETE FROM  [LH_Z_MONTH_JD] where STCD in ('','')  --水位统计表：月表
DELETE FROM  [LH_Z_DAY_JD_MinMaxAvg] where STCD in ('','')  --水位统计表：最大最小值表
DELETE FROM  [LH_Z_DAY_XD] where STCD in ('','')  --水位统计表：日表
DELETE FROM  [LH_Z_MONTH_XD] where STCD in ('','')  --水位统计表：月表
DELETE FROM  [LH_Z_DAY_XD_MinMaxAvg] where STCD in ('','')  --水位统计表：最大最小值表
DELETE FROM  [Ep_SQ_JC] where STCD in ('','')  --预警
DELETE FROM  [LH_Z_R] where STCD in ('','')  --实时表

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。