Watch this video: https://www.youtube.com/watch?v=FsVpkamX–Q&t=166s
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
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more