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

I am trying to implement sorting facility from client side code in GridView Control. So how can I fill up an Array inside client side code (using JavaScript), i want to assign my DataSet object declared and filled up on Server side(in code behind) to the array (on client side)

0 Answers   HCL,

---

How to send auto matic emails based on scheduled tasks to several of my clients

6 Answers  

---

What is the Web.config file used for? a) To store the global information and variable definition for the application. b) Configures the time that the server-side codebehind module is called c) To Configure the Web Server. d) To Configure the Web browser.

8 Answers   HCL, IBM, Syntax Softtech, Vypin, WideVision Technologies,

---

What is Razor View Engine

0 Answers   HCL,

---

what is view stat how it is use ?

2 Answers   Amazon,

---

What is CLS?

5 Answers   IBM, PrimeLine, TCS,

---

What is a web server? What are the load limits in it?

0 Answers   Wipro,

---

What are session state modes? List some of the important session state modes of asp.net.

0 Answers  

---

What is the biggest disadvantage of “Other Return Types” in Web API?

0 Answers  

---

What is the difference between session.abandon() vs clear()?

0 Answers  

---

Can you explain one critical mapping? Performance issue which one is better?

0 Answers  

---

Explain the scenario where we go for inpro and outpro session?

3 Answers  

---