Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

How to use transactions efficiently : transact sql

0 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

What is the difference between sql and t sql?

0 Answers  

---

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

---

Explain unique key in sql.

0 Answers  

---

what is recursive stored procedure? : Sql dba

0 Answers  

---

What are local and global variables and their differences?

0 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---