diff options
Diffstat (limited to 'task7_procedures.sql')
| -rw-r--r-- | task7_procedures.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/task7_procedures.sql b/task7_procedures.sql index a93dd3f..891db18 100644 --- a/task7_procedures.sql +++ b/task7_procedures.sql @@ -40,8 +40,11 @@ GO DROP PROCEDURE calculate_order_price GO +INSERT INTO Boxes (order_id, warehouse_id, wrapping_id, volume, weight) +VALUES (100020, 1, 1, 0.1, 10); + DECLARE @price INT; -EXEC calculate_order_price 12, @price OUTPUT; +EXEC calculate_order_price 100020, @price OUTPUT; PRINT @price GO |