What are the types of stored procedures in an SQL server?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

The types of stored procedures present in an SQL server are listed as follows: –

  • User-defined stored procedures– these are the modules or routines which encapsulate code for reuse. There are 2 types of user-defined stored procedures:
  • Transact-SQL: It is a collection of transaction SQL statements which takes and returns user-specified parameters.
  • CLR: It is a reference to the Microsoft .NET framework.
  • Extended stored procedures– with the help of these procedures, you can create your own external routine in a programming language.
  • System stored procedures– these are used to perform various administrative activities in the SQL server.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Stored procedures Interview questions

    What do you understand by a stored procedure?

    The group of SQL statements which are or have been stored in the server database is known as a stored procedure. Input ..

    Stored procedures Interview questions

    Mention the uses of stored procedures.

    Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:Stored p..

    Stored procedures Interview questions

    What are the advantages of using a stored procedure?

    The following are the advantages of using a stored procedure: – It reduces the network usage between the client and t..