Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What a stored procedure in Sql Server??

user-image
Question added by Wassim Helal , Formateur , Ministère du tourisme
Date Posted: 2014/05/20
Abdullah Abdurrahman
by 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
by 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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.