What is Stored Procedure in SQL-Server?

What is Stored Procedure in SQL-Server?

  • Stored Procedure is write SQL Query in Specific format in SQL Server and call them from your application, instead of writing queries inside your program code. 
  • Stored Procedures are precompiled Transact-SQL statements which is stored in a SQL Server database. 
  • Stored procedure is a simple SQL Statement, which is precompiled. 
  • SP Increase the performance of your application.
    Create a Stored Procedure in SQL-Server

    CREATE PROCEDURE [STUDENT_SELECT]
      (


        //here is your parameter for insert/update/delete purpose.
      )
      AS


     BEGIN


         SELECT * FROM STUDENTMST


     END

Leave a Reply

Your email address will not be published. Required fields are marked *

18 − 4 =