MSSQL - Stored procedure inside stored procedure

Watch this example on YouTube



CREATE PROCEDURE GetOrders
AS
BEGIN
    SET NOCOUNT ON;

    Declare @now datetime = getdate()
    Exec SetUpdateRecord @now
    Select * from Orders
END
GO