qq_40969534的博客

The server selected protocol version TLS10 is not accepted by client preferences [TLS12]删掉这几个加密算法

当天数据：select * from tableName wheredatediff(day, 字段名,getdate())=0本周数据：select * from tableName wheredatediff(week, 字段名,getdate())=0本月：select * from tableNamewheredatediff(month, 字段名,getdate())=0本季度：内select * from tableNamewheredatediff(quart...

round( `a`.`Pump_Design_Head`, 1 ) AS `Pump_Design_Head`

create procedure PRO_RAIN_HOURS @tm datetime as begin select a.stcd ,a.rn, b.测站名称 from (SELECT stcd,sum(rn) as rn FROM [dbo].[Rain_RealTime] where tm >=@tm GROUP BY stcd)a join VW_StationInfo b on a.stcd =b.测站代码 where b.[启用标志]=1 end...

select DATEADD(day, -1, GETDATE())