C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !






Stored Procedures


Posted Date: 13 Jun 2008    Resource Type: Definitions    Category: General
Author: BuntyMember Level: Diamond    
Rating: Points: 10



Introduction:


A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a sproc or SP) are actually stored in the database data dictionary
The stored procedures can be classified as:

User-Defined Procedures:


The user-defined stored procedure are created by users and stored in the current database.


System Stored Procedures:


The system stored procedures have names prefixed with sp_ .These primarily support various administrative tasks that help to manage SQL Server.The system databases,which store system stored procedures,are master and msdb databases.


Temporary Stored Procedures:


The temporary stored procedures have names prefixed with the # symbol.They are stored in the tempdb database and are automatically dropped when the client connection to server terminates.


Remote Stored Procedures:


The remote stored procedures are procedures that are created and stored in databases on remote servers.These remote stored procedures can be accessed from various servers,provided the users have the appropriate permissions.



Extended Stored Procedures:


These are Dynamic-Link Libraries (DLL's)that are executed outside the SQL Server environment.They are identified by the prefix xp_ .




Responses

Author: Chandra Sheker.G    14 Jun 2008Member Level: Gold   Points : 0
good


Author: chaithanya    14 Jun 2008Member Level: Silver   Points : 1
Very nice post which gives a brief description about the types of stored procedures.


Author: Roshan Panpaliya    15 Jun 2008Member Level: Bronze   Points : 1
This article contain very use full information.
Good work Mr. Satyanarayan.Keep sendind such useful article.



Author: sreelatha yalamanchi    16 Jun 2008Member Level: Silver   Points : 1
hi the information you have given is really very useful for me.....plz keep on posting such useful information more.......


Feedbacks      
Popular Tags   What are tags ?   Search Tags  
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Notification Delivery Services - Cache Invalidation Mechanism in Yukon
Previous Resource: Interfaces
Return to Discussion Resource Index
Post New Resource
Category: General


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design


Contact Us    Privacy Policy    Terms Of Use