lsyyx

摘要： SELECT*FROM Customers DELETE FROMCustomers WHERE PKId=1 UPDATE Customers SET UserID='sq' WHERE PKId=1 INSERT INTO Customers(UserID,TrueName) VALUES ('... 阅读全文

摘要： Sql Server查询指定范围(一周、一月、本周、本月等)内的数据SQL查询当天日期在一周年的数据select*fromShopOrderwheredatediff(week,ordTime,getdate()-1)=0查询当天的所有数据select*fromShopOrderwheredated... 阅读全文