xingqi.sql

sql server 2000 系统 数 据 库 编 程

declare @number int
set @number = 8
select case @number
when 1 then 
'周一'
when 2 then 
'周二'
when 3 then
'周三'
when 4 then
'周四'
when 5 then 
'周五'
when 6 then 
'周六'
when 7 then 
'周日'
else '输入的格式错误'
end xingqi