SQL SERVER 在mapper中插入数据返回ID

参考：

书写格式：https://blog.csdn.net/ljh602755608/article/details/80728148

获取ID方式：https://blog.csdn.net/alexander_frank/article/details/51513101

<insert id="insert" parameterType="Object" keyColumn="obj_id" keyProperty="objId">
  insert into light (obj_id, obj_address)
  values ( #{objNo,jdbcType=VARCHAR}, #{objAddress,jdbcType=VARCHAR})
  SELECT SCOPE_IDENTITY()
</insert>