摘要：1、select dateadd(day,6-datepart(weekday,getdate()),getdate())=>这周五select dateadd(day,-datepart(weekday,getdate())-2,getdate())=>上周四2、[Sql Server]重新设置IDENTITY列重新从1开始记数 =>DBCCCHECKIDENT([mytabl... 阅读全文