sql语句
zi12zi
这个作者很懒,什么都没留下…
展开
-
sql用sql语句来备份库
BACKUP DATABASE hbcct to disk=c:/1.bak原创 2007-11-27 15:25:00 · 234 阅读 · 0 评论 -
sql做统计,case when
sql:select gwlb, count(case when (year(getdate())-year(rybirthday)) between 20 and 30 then rygh end) as 20-30,count(case when (year(getdate())-year(rybirthday)) between 30 and 40 then rygh end) as原创 2007-11-27 15:26:00 · 372 阅读 · 0 评论 -
数库值为null值相加方法
select 字段1,字段2,isnull(字段1,0)+isnull(字段2,0) from 表原创 2007-11-27 15:38:00 · 325 阅读 · 0 评论