sample74.sql

T-SQL示例大全

/* 文件名称: Sample74.sql */

DECLARE @nType int
SET @nType = 1

SELECT CASE @nType
         WHEN 1 THEN '资讯部'
         WHEN 2 THEN '生产制造部'
         WHEN 3 THEN '会计部'
         WHEN 4 THEN '业务部'
         ELSE '设立中...'
       END