Answer / vidit tyagi

triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure

Answer / sivasiva

Triggers:
Triggers create event that event pass the value for
insert,update delete automatically updated value for the
table.triggers are event driven sepecified procedure.store
and managed by DBMS.automatically fires the value.

Store procedure:
Fast Accesing.Reduse network traffic.sepatre businees rules
and logic from presentation layer

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

How many levels of sp nesting is possible?

0 Answers  

---

How are the exceptions handled in sql server programming?

0 Answers  

---

What do you understand by replication in sql server?

0 Answers  

---

What is explicit cursors?

0 Answers  

---

---

How to find out the list schema name and table name for the database?

0 Answers  

---

List down some advantages of sql stored procedure?

0 Answers  

---

What is shared lock?

0 Answers  

---

What is normalization process?

0 Answers  

---

How to sort query output in descending order in ms sql server?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---