xlcchj0的专栏

Insert： SET IDENTITY_INSERT dbo.orderlist ONinsert into dbo.orderlist (orderID,supplierNum,staffNum,orderNum,orderTime,money) values(25,'s2','zg9','or25','2021-11-11',9999) SET IDENTITY_INSERT dbo.orderlist OFF Update： update dbo.orderlistset staffNu.

group by 1. select 语句中要选择的列，要么是group by后面的列，要么是作为聚合函数中的参数