Answer Posted / radha sri seshu.kolla

I THINK TRIGGER FIRES FIRST, BCZ WHEN U WRITE A TRIGGER
LIKE 'BEFORE INSERT ON EMP' EVENT. THIS TRIGGER WILL FIRE
IMMEDEATELY BEFORE THE DATA IS ABOUT TO INSERT IN THE
TABLE.WHERE AS IN THE CASE OF CONSTRAINTS, WHEN YOU INSERT
THE DATA,THE DATA GOES FOR CONSTRAINT VALIDATION THEN THE
DATA WILL BE REJECTED(IF THE DATA VIOLATES THE CONSTRAINT
RULE). I AM NOT 100% SURE. THIS IS JUST MY IMAGINATION.

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1042

---

what is subquery? : Sql dba

1135

---

How do you take the union of two tables in sql?

985

---

What is a table in a database?

1045

---

what is transaction? : Sql dba

1008

---

Is sqlite free?

975

---

Enlist some predefined exceptions?

1060

---

What is union and union all keyword in sql?

1043

---

What is the left table in sql?

963

---

What is a recursive stored procedure?

1185

---

Which data dictionary views have the information on the triggers that are available in the database?

1236

---

List out the acid properties and explain?

953

---

Is nosql faster than sql?

1023

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1190

---

What is the purpose of normalization?

1042

---