This is to be written in SQL for MS Access. Question) 12 11. What command would

Question

This is to be written in SQL for MS Access.

Question) 12

11. What command would you use to delete the Books table trom the Henry Books database! (o Book table.) . How would 12. Write a stored procedure that will change the price of a book with a given book code and quality ty is excellent t you use this stored procedure to change the price of any copy of book 1351 whose quali $22.95? oks at t 13 Assume the Branch table contains a column called TotalValue that represents the total price for all bo

Explanation / Answer

In order to alter/update the data of one or more records in a table, we can use SQL Update statement.

Syntax:

Update table_name

Set col1 =val1, cal2 = val2..

where condition;

Now,

Update Books

Set price = x

Where book code = y AND quality = z

E.g.)

Update Books

Set price = 22.95

Where book code = 1351 AND quality = 'excellent';

Hope it helps, do give your valuable response.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.