摘要：--修改日,从1号修改到10号UPDATE CHECKINOUT SET CHECKTIME=DATEADD(DAY,9,CHECKTIME) WHERE YEAR(CHECKTIME)=1970 and DAY(CHECKTIME)=01--修改小时,从00点修改到6点UPDATE CHECKIN... 阅读全文

摘要：--查询行号select row_number()over(order by CHECKTIME )as RowNum,*from CHECKINOUT--更新id列为行号update CHECKINOUT set id=t.rowId from (select CHECKTIME, ROW_NUM... 阅读全文