离我回家还有多久(SQL版)
摘要：
SELECT IDENTITY(int, 1,1) AS ID_Num into #t FROM sysobjectsSELECT COUNT(*) AS 天数,SUM(CASE DATEPART(weekday,dt) WHEN 1 THEN 0 WHEN 7 THEN 0 ELSE 1 END) AS 工作日FROM (SELECT DATEADD(dd,ID_NUM-1,get... 阅读全文
posted @ 2004-08-03 11:42 Goodspeed 阅读(825) 评论(0) 推荐(0) 编辑