ym

返回当前插入数据库的idmybatis中（添加后面两个属性）<insert id="insertSelective" parameterType="com.jntech.apm.model.sqlserver.ProBasicInfor" useGeneratedKeys="true" keyProperty="probasicinforid">Java代码public ...

查找父子节点，在一张表中– with 一个临时表（括号里包括的是你要查询的列名）with tem_table(dept_id,parent_id,dept_name,curlevel,havechild)as(–1，初始查询(这里的parent_id='000’是我门数据中最底层的根节点)select dept_id, parent_id, dept_name, 1 as lev...

Sqlserver查询本周、本年、本月、本季度数据 1、select * from sysLog where DateDiff(dd,creatDate,getdate())=0 //当天 2、SELECT * FROM sysLog where creatDate between dateadd(week, datediff(week,0,GETDATE()-1),0) a...