zhoucm

摘要： 返回星期数：例如20051004是星期二SELECT DATEPART(WEEKDAY,CAST('20051004' AS DATETIME)+@@DATEFIRST)总是返回3SELECT DATEPART(WEEKDAY,CAST('20051004' AS DATETIME)+@@DATEFIRST-1)总是返回2返回某个星期的第一天和最后一天DECLARE @DATE DATETIMESET @DATE = GETDATE()SELECT @DATE-DATEPART(WEEKDAY,@DATE+@@DATEFIRST-1)+1,@DATE+7-DAT 阅读全文

摘要： USE [Test]GO/****** Object: Table [dbo].[Employees] Script Date: 2013/1/1 0:57:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Employees]( [id] [int] IDENTITY(1,1) NOT NULL, [lastname] [varchar](50) NULL, [firstname] [varchar](50) NULL, [birthday] ... 阅读全文

摘要： A good DI container,has some very clever features:• Dependency chain resolution: If you request a component that has its owndependencies (for example, constructor parameters), the container will satisfy thosedependencies, too. So, if the constructor for the MyEmailSender class requires animplementat 阅读全文