Name the different types of stored procedures?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Name the different types of stored procedures?
Question Posted on 18 Jun 2022

Home >> DataBase >> sql questions >> Name the different types of stored procedures?

Name the different types of stored procedures?
Stored procedure are mainly chunks of SQL Code which can be saved and reused. Below are the four types of stored procedure:-
(1)User-defined stored procedure:-These are created by users.
(2)System stored procedures:-These type of store procedures are default procedures which are placed permanently on the sytem.
(3)Temporary stored Procedures:-These types of store procedure are procedures that are dropped when session is closed.
(4)Remote stored prcedures:-These are prcodure that are created and stored on remote servers.

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)