Database Development (Sequence Objects)
Watch this video:
Complete the following tasks using DDL & DML commands, NOT THE GUI in the Microsoft SQL Server Management Studio. SHOW YOUR WORK!
1. Create a sequence for populating the Customer# column of the DB1.CASTEEL.CUSTOMERS table. When setting the start and increment values, keep in mind that data already exists in this table. The options should be set to not cycle the values and not cache any values, and no minimum or maximum values should be declared.
Sequence Goes Here.
Screen Shot Goes Here
2. Add a new customer row to the DB1.CASTEEL.CUSTOMERS table by using the sequence created in Question 1. The only data currently available for the customer is as follows:
· last name = Shoulders
· first name = Frank
· zip = 23567
Query Goes Here.
Screen Shot Goes Here
3. Create a sequence that generates integers starting with the value 5. Each value should be three less than the previous value generated. The lowest possible value should be 0, and the sequence shouldn’t be allowed to cycle. Name the sequence MY_FIRST_SEQ.
Sequence Goes Here.
Screen Shot Goes Here
4. Issue a SELECT statement that displays NEXTVAL for MY_FIRST_SEQ three times. What causes the error on the third SELECT?
Select Goes Here.
Select Goes Here.
Select Goes Here.
Screen Shot Goes Here
5. Change the setting of MY_FIRST_SEQ so that the minimum value that can be generated is –1000.
Alter Sequence Goes Here.
Screen Shot Goes Here