sample77.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

/* 文件名称: 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