生肖存储过程
来源:互联网 发布:英语网络词汇大全 编辑:程序博客网 时间:2024/03/29 20:12
update tbl_user set SHENGXIAO=(select case when year(@temp1)%12 = 0 then '8'
when year(@temp1)%12 = 1 then '9'
when year(@temp1)%12 = 2 then '10'
when year(@temp1)%12 = 3 then '11'
when year(@temp1)%12 = 4 then '0'
when year(@temp1)%12 = 5 then '1'
when year(@temp1)%12 = 6 then '2'
when year(@temp1)%12 = 7 then '3'
when year(@temp1)%12 = 8 then '4'
when year(@temp1)%12 = 9 then '5'
when year(@temp1)%12 = 10 then '6'
when year(@temp1)%12 = 11 then '7'
end)from tbl_user where ID=@i
when year(@temp1)%12 = 1 then '9'
when year(@temp1)%12 = 2 then '10'
when year(@temp1)%12 = 3 then '11'
when year(@temp1)%12 = 4 then '0'
when year(@temp1)%12 = 5 then '1'
when year(@temp1)%12 = 6 then '2'
when year(@temp1)%12 = 7 then '3'
when year(@temp1)%12 = 8 then '4'
when year(@temp1)%12 = 9 then '5'
when year(@temp1)%12 = 10 then '6'
when year(@temp1)%12 = 11 then '7'
end)from tbl_user where ID=@i
- 生肖存储过程
- 生肖属相
- 生肖配对
- 生肖计算
- 生肖宜忌歌
- 生肖趣谈
- 生肖速记
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- 存储过程
- CMD命令集锦
- Windows XP系统中如何屏蔽 Ctrl+Alt+Del、Alt+Tab以及Ctrl+Esc键
- 寻找发帖王---sql语句
- Javascript跨域和Ajax跨域解决方案
- 内存常见问题与调试技巧 ——C语言最大难点揭秘
- 生肖存储过程
- 学习最大子段和的动态规划算法的一些总结
- How to access other computer using different name/password
- 编译原理语法分析LR1
- 1000门课程中英互译
- 最简单的xsl转换最简单的xml
- windows错误代码一览表
- 变送器和传感器有什么区别和联系?
- 男人不成功的31个理由