Consider the procedure:
CREATE PROCEDURE GetOrders
@StartDate DATE = '2025-01-01',
@EndDate DATE = NULL
AS
SELECT * FROM Orders
WHERE OrderDate >= @StartDate
AND (@EndDate IS NULL OR OrderDate <= @EndDate);
If we run:
EXEC GetOrders;
What happens?

Question

Consider the procedure: CREATE PROCEDURE GetOrders  @StartDate DATE = '2025-01-01',  @EndDate DATE = NULL AS SELECT * FROM Orders WHERE OrderDate >= @StartDate AND (@EndDate IS NULL OR OrderDate <= @EndDate); 
 If we run:  EXEC GetOrders; 
 What happens?

Answer

c.  Returns all orders without filtering

Answer

b.  Throws an error because @EndDate is NULL

Answer

d.  Returns orders since 2025-01-01

Answer

a.  Requires explicit parameters

Crowdly

Consider the procedure: CREATE PROCEDURE GetOrders @StartDate DATE = '2025-01-0...

Want instant access to all verified answers on moodle.usth.edu.vn?