Problem
Create a new SEQUENCE for the Employees table. Have the new sequence start at next available Employee Id and increment it by 5's.
Add a single SELECT statement to confirm the sequence exists by selecting it from the appropriate meta data table containing sequence information in SQL Server.
Add an INSERT statement to add a new employee to the employees table using the following data:
Primary key - use the sequence's next value.
First Name - Don
Last Name - Cherry
Street Address - 28 Hanbury Drive
City - Cole Harbor
Province - Nova Scotia (use 2 digit code as per database format)
Postal Code - B4R 3F7
Area Code - 902
Phone - 555-3333
Birth Date - 1930-04-18
Add another INSERT statement to add another new employee to the employees table using the following data:
Primary key - use the sequence's next value.
First Name - Donnie
Last Name - Brasco
Street Address - 231 Maple Drive
City - Oakville
Province - Ontario (use 2 digit code as per database format)
Postal Code - L4X-1L9
Area Code - 289
Phone - 777-1221
Birth Date - 1939-09-01.