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....

What is left outer join in sql server joins?

0 Answers  

---

What is efficiency data?

0 Answers  

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

Give an example of why you would want to denormalize a database

0 Answers  

---

How to query multiple tables jointly?

0 Answers  

---

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

How to delete exactly duplicate records from a table?

0 Answers  

---

check, not null,unique

2 Answers   IBM,

---

How do I start sql server 2016?

0 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---