域名頻道IDC知識庫
sqlserver時間函數DATEDIFF介紹
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢當天日期在一周年的數據 select * from ShopOrder where dated...
標簽：sql批量更新多條數據
IDC知識庫
IDC領域專業知識百科平臺
IDC領域專業知識百科平臺
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢當天日期在一周年的數據 select * from ShopOrder where dated...