Answer / m.ramarathna

Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.


when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .

Answer / sanjay kumar dinda

Trigger is a procedure which is invoked automatically when
any DML operation occured on a table.

At the time of DML operation , inside trigger SQL provide
the dummy table ( inderted , deleted) , which stores the
errected rows....

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

What is a full text index?

0 Answers  

---

What is normalization of database?

0 Answers  

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

What is the difference function and stored procedure?

0 Answers  

---

Does group by sort data?

0 Answers  

---

Why do we need different type of parameter?

0 Answers  

---

What do you understand by triggers and mention the different types of it?

0 Answers  

---

What is data source document?

0 Answers  

---

What do you understand by check constraint in sql server?

0 Answers  

---

What do you mean by an execution plan? Why is it used?

0 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---