eg:
update Order set Order.DeliverStatus=2 from PE_Orders Order
WHERE Order.InputTime<='2011-05-20' AND Order.OrderType = 0
eg:
update Order set Order.DeliverStatus=2 from PE_Orders Order
WHERE Order.InputTime<='2011-05-20' AND Order.OrderType = 0
转载于:https://www.cnblogs.com/zhangqs008/archive/2011/05/19/2341135.html