摘要:
sqlserver 查询当天/本周/本月/本季度/本年的数据 当天数据:select * from tableName where datediff(day, 字段名,getdate())=0 本周数据:select * from tableName where datediff(week, 字段名 阅读全文
摘要:
update nvr_downfailed INNER JOIN( select nvr_restartnum from nvr_downfailed where downfile_id =(select max(downfile_id) from nvr_downfailed) ) b on nv 阅读全文
摘要:
using System; using System.Diagnostics; using System.Runtime.InteropServices; using System.Threading; using System.Timers; namespace ConsoleApp8 { cla 阅读全文
摘要:
https://blog.csdn.net/qq_36675754/article/details/81381341/ 阅读全文
摘要:
以下两个sql任意一个可查询 select @@basedir as basePath from dual ; show variables like '%basedir%'; 查看数据库data路径:以下查询任意一个均可 select @@datadir as dataPath from dual 阅读全文
摘要:
Console.WriteLine(DateTime.ParseExact(20210511102323.ToString(), "yyyyMMddHHmmss", new CultureInfo("zh-CN", true),DateTimeStyles.AllowInnerWhite).ToSt 阅读全文