Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What a stored procedure in Sql Server??

user-image
Question ajoutée par Wassim Helal , Formateur , Ministère du tourisme
Date de publication: 2014/05/20
Abdullah Abdurrahman
par Abdullah Abdurrahman , Software Development Manager , Global Computer Services

Its a prepared SQL Statement that you save before, then you can call this procedure over and over,you can call this procedure from even the SQL Server Console, or from Programming Language using SQLClient, or making the Procedure itself runs periodically or under event.

jagtarsingh leedar
par jagtarsingh leedar , Assistant Manager IT , Servify

A stored procedure is nothing more than prepared SQL code that you save so you can reuse the code over and over again.  So if you think about a query that you write over and over again, instead of having to write that query each time you would save it as a stored procedure and then just call the stored procedure to execute the SQL code that you saved as part of the stored procedure.

More Questions Like This