如何在存储过程内部调用另一个存储过程 EXEC
-- ============================================= -- 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
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步