-- ============================================= -- Author: <Author,,LY> -- Create date: <Create Date> -- Description: <Description, 改变订单的签收时间 > -- 测试通过 -- ============================================= ALTER PROCEDURE [dbo].[CHANGE_RECEIVE_ORDER_TIME] ( @order_id int, @rtime datetime, @receiver nvarchar(20) ) as begin update orders set receive_time = @rtime where order_id = @order_id update orders set order_status = '已签收' where order_id = @order_id update orders set receiver = @receiver where order_id = @order_id declare @tmp int EXEC [dbo].CHANGE_PRODUCT_STATUS_BY_ORDER @order_id,'已签收',@tmp end