sqlserver

 "templateSql": {
        "message": {
          "delete": "删除：总数{0}条，成功{1}条，失败{2}条。",
          "update": "更新：总数{0}条，成功{1}条，失败{2}条。",
          "edit": "修改：总数{0}条，成功{1}条，失败{2}条。",
          "add": "新增：总数{0}条，成功{1}条，失败{2}条。",
          "batSave": "批量保存：总数{0}条，新增成功{1}条，新增失败{2}条，删除成功{3}条，删除失败{4}条，修改成功{5}条，修改失败{6}条。",
          "treeSave": "信息分配：总数{0}条，新增成功{1}条，新增失败{2}条，删除成功{3}条，删除失败{4}条，修改成功{5}条，修改失败{6}条。"
        },
        "updateSql": "update {table_name} set {u_column} where {primary_where_sql}",
        "deleteSql": "delete from {table_name} where {primary_where_sql}",
        "insertSql": "insert into {table_name} ({i_column}) values  ({i_column_value});",
        "insertSqlReturn": "{insertSql} set @_id=SCOPE_IDENTITY();",
        "iterationSql": "with temp as (select {iteration_id} ID,{1iteration_parent_id} PARENT_ID from {table_name} WHERE {iteration_id}=@{iteration_id_value} {where_sql}  UNION ALL select T0.{iteration_id} ID,T0.{iteration_parent_id} PARENT_ID from temp,{table_name} T0 WHERE temp.id=T0.{iteration_parent_id} {where_sql_t0}) select ID VALUE from temp;",
        "insertSort": "(select isnull(min({insert_sort_name}),99999999)-3 from {table_name} where {insert_sort_name}>1000)",
        "clickSql": " update {table_name} set {u_column}=isnull({u_column},0)+1 where {primary_where_sql}",
        "dateDiffSort": "(case when datediff(mi,{date_diff_column},@_currentDate)<{date_diff_minute} then 0 else 1 end)",
        "dateDiffValue": "datediff(mi,{date_diff_column},@_currentDate)",
        "geographyFromText": "geography::STGeomFromText(@stFromText, 4326)",
        "geographyAsText": "{st_col_name}.STAsText() {st_col_name}",
        "geographySrid": 4326,
        "geographyWkid": 4326,
        "geographyPoint": "'POINT('+convert(varchar,{st_lng})+' '+convert(varchar,{st_lat})+')'",
        "geographyLine": "LINESTRING({st_line}))",
        "geographyPolygon": "POLYGON(({st_area}))",
        "geographyDistance": "(geography::STGeomFromText(@stStartLngLat, 4326).STDistance(geography::STGeomFromText(@stEndLngLat, 4326)))",
        "geographyDbDistance": "({st_geography}.STDistance(geography::STGeomFromText(@stEndLngLat, 4326)))",
        "geographyArea": "(geography::STGeomFromText(@stPolygon, 4326).STArea())",
        "geographyDbArea": "({st_geography})",
        "nullSql": "isnull({null_o},{null_new})"
      },