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 *

9 + 8 =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">