select * from dbo.DayLineLose
exec ListStructure 'DayLineLose'
select m_id,Meter_ID,Stamp from vw_meter where Tran_ID=1 select m_id,Meter_ID,Stamp from vw_meter where Stamp>0
exec ListStructure 'GBTerminal.F10'
sp_helpconstraint 'GBTerminal.F10' select * from tbZflx select * from Trans_Area 0 分表 1 总表 2 分总表 3 出口总表
select * from DayData where F_date='2011-4-14' and RTU_ID=9001 select * from DayData where F_date='2011-4-13' and RTU_ID=9001
select SUM(day_z) from DayData where F_date='2011-4-14' and RTU_ID=9005 select SUM(day_z) from DayData where F_date='2011-4-13' and RTU_ID=9005 select (47890.47-47351.58) 676.80 538.89 select (47890.47-47351.58)/80 6.736125 select 80*8.46 select * from GBTerminal.F10 select * from TermData.CLDDayData
sp_helpconstraint 'TermData.CLDDayData'
insert TermData.CLDDayData(tid,cldh,FreezeDate,m_date,Pwr_time,ygz,wgz) values(9001,2,'2011-4-14','2011-1-14 6:28','2011-4-13 19:59',100,null)
insert TermData.CLDDayData(tid,cldh,FreezeDate,m_date,Pwr_time,ygz,wgz) values(9005,2,'2011-4-13',GETDATE(),'2011-4-13 23:51',1172,null)
delete TermData.CLDDayData where tid=9005 and FreezeDate='2011-04-13'
select * from daydata where F_date='2011-4-15' and RTU_ID=9005 and M_ID=946
delete daydata where F_date='2011-4-15' and RTU_ID=9005 and M_ID=946
select a.tid,AreaCode,useid,cldh,stamp from GBTerminal.F10 a,GBTerminal.TerminalDec b where a.tid=b.tid
insert TermData.CLDDayData(tid,cldh,ygz,wgz,FreezeDate,pwr_time,m_date) select a.tid,2,0,0,'2011-4-14 0:00:00','0001-1-1 1:01:10','2011-4-15 11:59:56' from GBTerminal.F10 a,GBTerminal.TerminalDec b where cldh=2 and a.tid=b.Tid and AreaCode=1501 and useid=1214
