Answer / deepak baldia

A stored procedure is a set of SQL commands that has been
compiled and stored on the database server.

A trigger is a special kind of stored procedure that is
invoked whenever an attempt is made to modify the data in
the table it protects. Modifications to the table are made
using INSERT,UPDATE,OR DELETE statements.

Answer / michael jerold

sp means to execute set of quries in single sp.and we can
call manually.


Trigger means dml operation happens the event will fire
automatically. we can not call manually.

Answer / vim@l katiyar

stored procedure is collection of sql query/command.it is database object.it stored in databse and uses for validation data and data access from data source. but it has some disadvantage like this .if more than one SP uses same server .
server performance down and once create and use many times.

trigger is sql procedure that initiates action when database modification query perform.it is automatically create .it is not executed like stored procedure .it is also execute stored procedure . when data modification sql command executed then action performed by trigger

Is overloading possible in web services?

2 Answers   Microsoft,

---

Why is validation always done on the server? When does that occur?

2 Answers  

---

Explain what is postback in asp. Net?

0 Answers  

---

What is Runtime callable wrapper?

2 Answers  

---

What is indexing on asp.net?

0 Answers  

---

how can i insert array values and retreive in asp.net

3 Answers   TCS, Value Labs,

---

How u refer webservices?

0 Answers   Microsoft,

---

What is the server of asp.net?

0 Answers  

---

Which is the best institute for ASP.NET?

8 Answers   ABC Infotech, Tech Mahindra,

---

whats the purpose of AUTOPOSTBACK property for the controls in asp.net?

4 Answers  

---

What combination of methods are used to improve the speed of the fill() method of the DataAdapter? a) BeginFillData() and EndFillData() b) StartFillData() and EndFillData() c) BeginLoadData() and EndLoadData() d) StartLoadData() and EndLoadData()

2 Answers   Syntax Softtech, winfoware,

---

What are validator? Name the validation controls in asp.net? How do you disable them? Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?

0 Answers  

---