))
Episode 15: stored procedure in dbms
Fetch error
Hmmm there seems to be a problem fetching this series right now.
Last successful fetch was on February 27, 2024 04:00 (
What now? This series will be checked again in the next day. If you believe it should be working, please verify the publisher's feed link below is valid and includes actual episode links. You can contact support to request the feed be immediately fetched.
Manage episode 329858372 series 3346792
Content provided by Bhavik. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Bhavik or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.
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
…
continue reading
37 episodes
Share
