sample77.sql

来自「T-SQL示例大全」· SQL 代码 · 共 14 行

/* 文件名称: Sample77.sql */
DECLARE @Today int
SET @Today = DatePart(dw,Getdate())

SELECT 今天是 =  CASE 
                                    WHEN @Today = 1 THEN '星期天'
                                    WHEN @Today = 2 THEN '星期一'
                                    WHEN @Today = 3 THEN '星期二'
                                    WHEN @Today = 4 THEN '星期三'
                                    WHEN @Today = 5 THEN '星期四'
                                    WHEN @Today = 6 THEN '星期五'
                                    WHEN @Today = 7 THEN '星期六'
                                END