You have a table named Stores that has an XML column named OpenHours. This column contains
the opening and closing times.
<hours dayofWeek=“Monday” open=”8:00” closed=”18:00” />
<hours dayofWeek=“Tuesday” open=”8:00” closed=”18:00” />
…
<hours dayofWeek=“Saturday” open=”8:00” closed=”18:00” />
You need to write a query that returns a list of stores and their opening time for a specified day.
Which code segment should you use?
A.
DECLARE @Day VARCHAR(10) = ‘Tuesday’
SELECT
StoreName,
OpenHours.value(‘/hours[1]/@open’,’time’)
FROM Stores
WHERE OpenHours.value(‘/hours[1]/@dayofWeek’,’varchar(20)’) = @Day
B.
DECLARE @Day VARCHAR(10) = ‘Tuesday’
SELECT
StoreName,
OpenHours.value(‘/hours[1]/@open’,’time’)
FROM Stores
WHERE OpenHours.exist(‘/hours[@dayofWeek=sql:variable(“@Day”)]’) = 1
C.
DECLARE @Day VARCHAR(10) = ‘Tuesday’
SELECT
Storename,
OpenHours.query(‘data(/hours[@dayofWeek=sql:variable(“@Day”)]/@open)’)
FROM Stores
D.
DECLARE @Day VARCHAR(10) = ‘Tuesday’
SELECT
StoreName,
OpenHours.value(‘/hours[1][@dayofWeek=sql:variable(“@Day”)]/@open’,’time’)
FROM Stores