sudeep s kanakagiri
What is an Stored procedure in SQL?
By sudeep s kanakagiri in Databases & DBA on Oct 08 2013
  • Joe Wilson
    Jul, 2015 20

    A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.

    • 1
  • Kml Surani
    May, 2015 13

    A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.

    • 1
  • Manav Pandya
    Jan, 2018 17

    In simple terms Stored Procedures are a Group of queries which runs simultaneously based on their call , SP are capable of doing complex queries with easily manageable structure with Looping , Conditions , functions etc .

    • 0
  • Ramesh  Maruthi
    Aug, 2014 11

    Stored Procedures are a batch of SQL statements that can be executed in a couple of ways. Most major DBMs support stored procedures; however, not all do. You will need to verify with your particular DBMS help documentation for specifics.To create a stored procedure the syntax is fairly simple:CREATE PROCEDURE . AS So for example:CREATE PROCEDURE Users_GetUserInfo@login nvarchar(30)=nullASSELECT * from [Users]WHERE ISNULL(@login,login)=login

    • 0
  • Munesh Sharma
    Apr, 2014 13

    When we write a query again and again then we write that query as a stored procedure and we call that stored procedure name.

    • 0
  • Mukesh Kumar Tiwari
    Nov, 2013 9

    A SP is a group of sql statement for perform some job in database. To use SP at the place of query is very good and som ADV also..SP is fast then Query.. Security...example:creare procedure student (@name varchar(50) ) as begin select * from student_master where name=@name end

    • 0
  • Phani Kumar
    Oct, 2013 10

    A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.

    • 0
  • Phani Kumar
    Oct, 2013 10

    A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS