Skip to content
Episode 15: stored procedure in dbms episode artwork

May 26, 2022 4 min

Episode 15: stored procedure in dbms

from Be With Trends Hosted by Bhavik

Different Types of stored procedure sql Server A stored procedure is a precompiled set of one or more SQL statements that are stored on SQL Server. The benefit of Stored Procedures is that they are executed on the server-side and perform a set of actions, before returning the results to the client-side. This allows a set of actions to be executed with minimum time and also reduces the network traffic. Hence stored procedure improves performance to execute SQL statements. For more about stored procedure refer to the article CRUD Operations using Stored Procedures. A stored procedures can accept input and output parameters. Stored procedures can return multiple values using output parameters. Using stored procedure, we can Select, Insert, Update, Delete data in the database. Types of Stored Procedure Types of Stored Procedure Extended Procedure User-Defined Stored Procedure CLR Stored Procedure Summary

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 15: stored procedure in dbms

0:00 4:04

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Be With Trends?

This episode is 4 minutes long.

When was this Be With Trends episode published?

This episode was published on May 26, 2022.

Can I download this Be With Trends episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.