![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql server
李木子QQ
这个作者很懒,什么都没留下…
展开
-
sql server
select convert(varchar(7), getdate(), 23)//2006-05select datediff(week, '2020-11-29', getdate())//上周天到周六select datediff(week, dateadd(dd, +1, '2020-11-29'), dateadd(dd, +1, getdate()))//上周六到周五原创 2020-11-25 13:57:27 · 124 阅读 · 0 评论 -
sql server 数据库有值执行update,没有则执行insert语句
<insert id="save" parameterType="java.util.List"> <foreach collection="list" item="s" index="index" separator=";"> IF EXISTS(SELECT * FROM student WHERE id=原创 2018-11-30 14:32:36 · 1700 阅读 · 1 评论 -
sql server查询所有上级/下级
with test_student(stu_id, stu_name)as(select stu_id, stu_namefrom sys_studentwhere school_id = ‘1’ and del_flag = 0union allselect a.parent_id, a.stu_id, a.stu_namefrom sys_student ainner joi...原创 2018-12-10 17:18:46 · 2194 阅读 · 0 评论