Answer / vandana chand

Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.

Answer / sankar

1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.

2)We can call Trigger inside the store procedure. But
reverse is not possible.

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

How to configure odbc dsn with different port numbers?

0 Answers  

---

Define full outer join in sql server joins?

0 Answers  

---

What is raid and what are different types of raid levels?

0 Answers  

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---

---

How to receive returning result from a query?

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

How to verify a user name with sqlcmd tool?

0 Answers  

---

Explain Different types of Projects?

1 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What are the types of constraints?

1 Answers  

---

How do you create a data source?

0 Answers  

---