摘要：自定义config的作用主要是增强config的可读性，容易管理，直接进入正题先来比较一下使用AppSettings: 使用custom section: 下面是创建过程Step1 建立自定义classusing System;using System.Configuration;public class BlogSettings : ConfigurationSection{ private static BlogSettings settings = ConfigurationManager.GetSection("BlogSettings") as BlogSetti 阅读全文

摘要：SQL Server 本地时间和UTC时间的相互转换的代码DECLARE @LocalDate DATETIME,@UTCDate DATETIME,@LocalDate2 DATETIMESET @LocalDate = GETDATE()SET @UTCDate = DATEADD(hour, DATEDIFF(hour,GETDATE(),GETUTCDATE()), @LocalDate)SET @LocalDate2 = DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), @UTCDate)SELECT '1. Now&# 阅读全文