Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
Software ==> | SQL (203 exercises) |
Topic ==> | Testing conditions (3 exercises) |
Level ==> | Average difficulty |
Subject ==> | SQL training |
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.
If you don't have a copy of the Music_01 database, follow the instructions at the following link to create it: www.wiseowl.co.uk/sql/exercises/standard/using-sql-server/5257/
Open the Vali Date Parameters.sql file in the folder shown above and execute the script to create a stored procedure.
Create a new script to test the procedure, passing in any dates to the procedure's parameters.
This example returns albums released in 1992.
If we use too late a date for the @StartDate parameter or too early a date for the @EndDate parameter then we may not return any results. Your job is to add code to the stored procedure to validate the values passed in to the parameters.
In the stored procedure, use a variable to capture the maximum date in the Release_date column of the Album table.
Use an IF statement to check if the value passed in to the @StartDate parameter is after this date and shows a message then exits the procedure if so.
Your message could resemble this one.
Use the same technique to check if the value passed to the @EndDate parameter is before the earliest album release date.
An example of the message you could show.
Test that the procedure works then save and close the scripts.
You can find other training resources for the subject of this exercise here:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.