562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
This will generate the database that you'll need to use in order to do this exercise (note that the database and script are only to be used for exercises published on this website, and may not be reused or distributed in any form without the prior written permission of Wise Owl).
Create a query which lists out all of the events which took place in February 2005:
Your query should return these two events.
To put it another way, list out all the events which took place between 1st February 2005 and 28th February 2005.
Save this query as February 2005, then close it down.
|When:||22 Nov 19 at 13:21|
WHERE EventDate LIKE '2005-02%'
WHERE EventDate BETWEEN '2005-02-01' AND '2005-02-28'
|When:||22 Nov 19 at 14:36|
Use the YEAR function for an even easier way ...
|When:||26 Nov 19 at 16:00|
WHERE Year(EventDate) = '2005' AND Month(EventDate) = '2'
WHERE Year(EventDate) = '2005'
AND Month(EventDate) = '2'
AND DAY(EventDate) BETWEEN '1' AND '28'
|When:||26 Nov 19 at 16:05|
Better - but you shouldn't put the inverted commas round the numbers, as they aren't text!
|When:||27 Jul 18 at 19:57|
where DATEPART(yyyy, EventDate) = 2005 and
DATEPART(month, EventDate) = 2
25 Aytoun Street