楊 bey kuen的部落格

DUMP TRANSACTION 資料庫名稱 WITH NO_LOG
dbcc shrinkdatabase(資料庫名稱)

//本月最後一天
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)) //取得本月天數
SELECT Day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))) //顯示星期幾
select datename(weekday,getdate()) //本月第一個星期一
select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), 0) //本年最後一天
SELECT dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0)) //本季得第一天
SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0) //今年的第一天
SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) //本週的星期一
SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) //去年的最後一天
SELECT dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)) //判斷今年是否為閏年
SELECT case day(dateadd(mm, 2, dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)))) when 28 then '平年' else '閏年' end //這個季度有幾天
declare @m tinyint,@time smalldatetime
select @m=month(getdate())
select @m=case when @m between 1 and 3 then 1
when @m between 4 and 6 then 4
when @m between 7 and 9 then 7
else 10 end
select @time=datename(year,getdate())+'-'+convert(varchar(10),@m)+'-01'
select datediff(day,@time,dateadd(mm,3,@time))