Question: I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update

I need the answer as soon as possible I need the answer as soon as possible 1. Write and execute

1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f. Instead of delete 2. Write and execute one example of each of following stored procedure a. Insert stored procedure with two parameters b. Update stored procedure with two parameters c. Delete stored procedure with two parameters CREATE TRIGGER Trigger_2 ON EMP AFTER UPDATE AS BEGIN UPDATE EMP SET SAL - 500000 WHERE DEPTNO - 30 END UPDATE EMP SET SAL = 100 WHERE DEPTNO = 20 Take any "Emp" table and do in MS SQL SERVER according to give picture above.This is sample

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

I need the answer as soon as possible 1. Write and execute one example of each of following triggers a. After insert b. After update c. After delete d. Instead of insert e. Instead of update f....

Q:

MySQL Multiple Choice Answer as soon as possible 1. One of the limitations of views is that they cannot be used as part of the definition of another view. (a) True (b) False 2. A view can have...

Q:

MySQL Multiple Choice Answer as soon as possible 1. In many ways, views are treated as tables in MySQL. (a) True (b) False 2. When a view in MySQL is created, the data required to return the results...

Q:

MySQL Multiple Choice Answer as soon as possible 1. In many ways, views are treated as tables in MySQL. (a) True (b) False 2. When a view in MySQL is created, the data required to return the results...

Q:

Let T, ) be a game tree (arborescence). For every non initial node, call p(t) = sup (t) the immediate predecessor of t. Show that 1. p(t) is unique for every t T\W. 2. There is a unique path between...

Q:

Why is the sales forecast the key component of a financial model?

Q:

= today ( ) is the formula used to display the date and current time. True False

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

What is the difference between a traditional interview question and a behavioral interview question? (Objective 3)

Q:

Technology. Use a website to locate salary information for a beginning accountant, administrative assistant, computer programmer, and finance manager in the largest city in your state. In an e-mail...

Q:

Go to the Student Resources section of the website for Chapter 17. Retrieve and print two copies of the employment application form. Read the directions carefully and then complete the entire form....