What do mean Stored procedure ?

Posted by Srinivasulu.enugu under Sql Server on 6/18/2011 | Points: 10 | Views : 4981 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Using stored procedure , we can reduces network traffic , right ?

How is it possible ? Can anybody explain detail ?

Srinivasulu Enugu

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: SheoNarayan on: 6/18/2011 [Administrator] HonoraryPlatinum | Points: 25

0	I am not sure but up to my knowledge stored procedure has nothing to do with network traffic. Either you execute the SQL statement or Stored procedure from the code both gets executed in the sql server database and the actual data is returned to the application. That data will be same for the SQL either you execute using direct SQL or Stored procedure. Stored Procedure makes your application runs faster as the code written in the stored procedure is pre-complied and SQL server doesn't have to generate its plan at run time. Read this thread for more details http://www.dotnetfunda.com/forums/thread2838-what-is-the-use-of-storedprocedure.aspx. Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Srinivasulu.enugu, if this helps please login to Mark As Answer. \| Alert Moderator

I am not sure but up to my knowledge stored procedure has nothing to do with network traffic. Either you execute the SQL statement or Stored procedure from the code both gets executed in the sql server database and the actual data is returned to the application. That data will be same for the SQL either you execute using direct SQL or Stored procedure.

Stored Procedure makes your application runs faster as the code written in the stored procedure is pre-complied and SQL server doesn't have to generate its plan at run time.

Read this thread for more details http://www.dotnetfunda.com/forums/thread2838-what-is-the-use-of-storedprocedure.aspx.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

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

Posted by: Vilasgite080 on: 6/19/2011 [Member] Starter | Points: 25

0	hi srinvaslu... http://www.c-sharpcorner.com/UploadFile/73ba73/7161/ ------------------------------------------------------------------------------------------------------ if this helps you...then Accept as Answer! Srinivasulu.enugu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Lakn2 on: 6/20/2011 [Member] Starter | Points: 25

0	the biggest use of stored procedure is only one time compilation. Thanks&Regards LakshmiNarayana Nalluri. Srinivasulu.enugu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriramnandha on: 11/24/2011 [Member] Starter | Points: 25

0	Hi, 1)Stored Procedure is the Predefined collection of SQL Statements,its Precompiled Execution it will reduce the Client/Server Network Traffic.. 2) Easy to Error Handling in Stored Procedure 3) Better Performance. 4) More number of SQL Statements can execute single Stored Procedure. 5) Maintain the Security. Hope This will help Regards Sriram.R sriram Srinivasulu.enugu, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,

1)Stored Procedure is the Predefined collection of SQL Statements,its Precompiled Execution it will reduce the Client/Server Network Traffic..
2) Easy to Error Handling in Stored Procedure
3) Better Performance.
4) More number of SQL Statements can execute single Stored Procedure.
5) Maintain the Security.

Hope This will help

Regards
Sriram.R

sriram

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

Latest Posts