interview purpose i want answers

Posted by Ramana under Interview Questions on 3/19/2012 | Points: 10 | Views : 845 | Status : [Member] | Replies : 3
what is stored procedures?waht is the use of stored procedures?




Responses

Posted by: Patel28rajendra on: 3/20/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

A stored procedure is a group of T-SQL statements compiled into a single execution plan.


purpose to use store procedure

1.Reduced client/server traffic
2.Efficient reuse of code and programming abstraction
3.To prevent Sql Injection ( secure )


R D Patel

Ramana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/20/2012 [Member] Starter | Points: 25

Up
0
Down
Check
This

http://msdn.microsoft.com/en-us/library/aa174792%28v=sql.80%29.aspx

R D Patel

Ramana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/20/2012 [Member] Starter | Points: 25

Login to post response