TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About Procedures
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Nimit Joshi (4)
Abhimanyu K Vatsa (3)
Jitendra Mesavaniya (3)
Vijay Prativadi (3)
Senthilkumar (3)
Satyaprakash Samantaray (3)
Mahesh Chand (2)
Prashanth Chindam (2)
Jignesh Trivedi (2)
John Godel (2)
John Charles Olamendy (2)
Dinesh Kushwaha (2)
Akshay Phadke (2)
Bechir Bejaoui (2)
Scott Lysle (2)
Dan Clark (2)
Nilesh Jadav (1)
Akshima Aggarwal (1)
Gaurav Gupta (1)
Veerendra Annigere (1)
Lajapathy Arun (1)
Abhishek Yadav (1)
Arun Potti (1)
Sai Sherlekar (1)
Sardar Mudassar Ali Khan (1)
Ishika Tiwari (1)
Harpreet Singh (1)
Vithal Wadje (1)
Laishram Priyokumar Singh (1)
Sandeep Singh Shekhawat (1)
Harshit Pandey (1)
Shubhankar Banerjee (1)
Diwakar Tiwari (1)
C# Curator (1)
Venkatesan Jayakantham (1)
Rakesh Kalluri (1)
Abhishek Mishra (1)
Dennis Thomas (1)
Gaurav Tomar (1)
Munib Butt (1)
Abhishek Kumar Ravi (1)
Burak Seyhan (1)
Munesh Sharma (1)
Surapureddy Sriram (1)
Mangesh Kulkarni (1)
Debasis Saha (1)
Monica Rathbun (1)
Jaipal Reddy (1)
Om Agarwal (1)
Jamil Moughal (1)
Vijay Kumar (1)
Rohatash Kumar (1)
Abhishek Jaiswal (1)
Adalat Khan (1)
Sanwar Ranwa (1)
Sachin Kalia (1)
K V Ramana (1)
Suraj Sahoo (1)
Saillesh Pawar (1)
Sharad (1)
Ramchand Repalle (1)
Ashish Nakil (1)
Sateesh Arveti (1)
Saineshwar Bageri (1)
Rahul Bansal (1)
Sharad Gupta (1)
Satya Akkinepally (1)
Faizan Ahmed (1)
Shashi Ray (1)
Karthika Palaniswamy (1)
Faheem Ahmad (1)
Ashish Singhal (1)
Vilas Gite (1)
Srihari Chinna (1)
Michael Livshitz (1)
Paul Rony (1)
Santhosh Veeraraman (1)
Related resources for Procedures
No resource found
How to Bind and Perform Update, Edit, Delete Operation on DataList Control in 3 Tier in ASP.Net
5/1/2024 11:10:55 AM.
Learn how to implement CRUD operations on a DataList Control in ASP.NET using C#. This tutorial guides you through creating a three-tier architecture with an SQL Server Database, designing the UI, wri
Using Stored Procedures in MySQL Enhanced Code Performance
4/30/2024 6:14:17 AM.
Stored Procedures in MySQL offer a streamlined approach to executing complex or frequently used SQL logic with a single call, supporting input parameters, procedural logic, and return values.
Mapping TVFs Using Entity Framework Database First
4/24/2024 7:43:49 AM.
Map table-valued functions (TVFs) in Entity Framework Database First by importing them as function imports. Utilize EDM Designer to create complex types for TVF results, enhancing data retrieval and m
Entity Framework 6 CRUD Stored Procedures: Code-First Approach
4/23/2024 11:22:38 AM.
Learn how to implement Insert, Update, and Delete operations using stored procedures in Entity Framework 6 with a Code First approach. This tutorial covers setting up stored procedures, mapping them t
SQL Stored Procedures: Benefits, Implementation & Best Practices
4/19/2024 9:52:48 AM.
Stored procedures are a powerful feature of SQL databases that allow developers to encapsulate SQL logic and execute it as a single unit. In this article, we'll delve into the concept of stored pr
Select Stored Proc With Raw SQL Query Via EDF Framework
4/18/2024 10:43:47 AM.
Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational m
MERGE Stored Procedures in SQL Server
4/16/2024 8:14:21 AM.
In this article, I present how to use the MERGE statement in a stored procedure to merge a single record and how to use it to merge a list of records by using Table-Valued parameters in SQL Server.
Table-Valued Parameters in SQL Server
4/16/2024 5:42:55 AM.
Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data man
Using Table Type Parameter In .NET Core
4/5/2024 11:24:07 AM.
In many cases, we need to send a list of objects to the stored procedure to save or update the list of data in the database, which helps in increasing the performance of the application. Here I'll
Dynamically Getting Stored Procedures Collection From SQL Server Using C#
4/4/2024 9:32:40 AM.
In this article, we will learn how to dynamically fetch stored procedures from Microsoft SQL Server using C# for enhanced database interaction. This tutorial explores C#'s capabilities to programm
Grant Execute Or View Permission To Stored Procedures In SQL Server
4/4/2024 8:53:54 AM.
In this article we’ll learn how we can grant execute permission or view permission on stored procedures. We’ll also see why users require explicit permission on stored procedures.
How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?
4/3/2024 10:45:55 AM.
Querying Dataverse in Microsoft SQL Server Management Studio (SSMS) involves using Transact-SQL (T-SQL) to interact with tables, views, indexes, and stored procedures. Understanding entity relationshi
Practical Introduction To Entity Framework: Day 2
3/6/2024 10:30:54 AM.
This article provides a comprehensive guide on executing stored procedures using Entity Framework. It covers creating stored procedures in SQL Server, adding entity models to projects, and calling aut
Efficient API Development Database Operations in ASP.NET Core Web Using Dapper and Stored Procedures
12/27/2023 4:28:51 PM.
Employing Dapper in ASP.NET Core for database operations brings a streamlined approach to handling data, ensuring efficient and straightforward interactions. When complemented with stored procedures,
How to Create Stored Procedures for CRUD?
12/20/2023 11:13:05 AM.
In this article, we will learn how we can create Stored Procedures for CRUD operations in SQL Server.
Stored Procedures In SQL Server
12/6/2023 9:44:18 AM.
This tutorial explains everything about SQL Server Stored Procedures including creating a stored procedure, updating a stored procedure, deleting a stored procedure, and executing a stored procedure i
Working with OleDb Data Adapters
11/20/2023 2:55:24 PM.
This step by step article guides you to create your database applications using OleDb Data Adapters in VS.NET.
CRUD Stored Procedures in Azure Cosmos DB
10/26/2023 7:43:54 AM.
In this article, we will learn how to create the stored procedures in the Azure Cosmos DB for inserting, reading, updating, and deleting the Azure Cosmos DB collection items.
Writing Managed Stored Procedures using C#
9/18/2023 10:43:36 AM.
This article is trying to explain the simple and required steps that are require starting the creation of Manage Stored Procedure using C# and using them.
Good Practices to Write Stored Procedures in SQL Server
9/8/2023 9:35:57 AM.
This explains the good practices for writing stored procedures in SQL Server and the advantages of writing stored procedures.
Introduction of Stored Procedures
8/9/2023 11:01:58 AM.
A stored procedure is a set of precompiled SQL statements that are stored in a database. It is designed to perform a specific task or a series of tasks and can be executed by calling its name rather t
How to Implement Login Stored Procedures with Node.js and MySQL?
7/27/2023 9:44:38 AM.
In this article, we learn how to create a login stored procedure MySql and how to call Stored Procedure in Node.js.
Encryption of Stored Procedures in SQL Server
7/25/2023 6:06:04 AM.
The encryption of stored procedures in SQL Server is a security feature that enables developers to protect the sensitive business logic implemented within the database. By using the WITH ENCRYPTION op
How to use MySQL Stored Procedures
5/2/2023 4:49:52 PM.
MySQL Stored Procedures are pre-compiled SQL code blocks that are created and stored in the database and may be executed whenever necessary for better performance and security.
Stored Procedures Vs Functions In SQL - Types, Differences, And Best Practices
4/3/2023 5:48:00 AM.
This article provides a comprehensive guide to stored procedures and functions in SQL, including their types and differences. It explains how these powerful tools can simplify database management, enh
Inserting & Retrieving Images from SQL Server Database without using Stored Procedures
3/9/2023 11:16:11 AM.
In this article you will learn how to Insert & retrieve images from SQL server database without using stored procedures.
Stored Procedures
2/16/2023 7:02:26 AM.
In this article I will explain you about stored procedure. How to create, execute and alter stored procedure. Why to use stored procedures and advantages of stored procedures.
Is it Possible to Use the Select Statement to Access Stored Procedures
2/13/2023 5:54:49 AM.
In this article, you will learn how it is possible to use the select statement to access stored procedures.
CLR Stored Procedures in SQL Server
2/3/2023 7:57:46 AM.
In this article, we will learn about CLR Stored Procedures in SQL server.
Unlock the Secrets of the Rank Function in SQL Server
1/18/2023 3:14:41 PM.
Unlock the power of SQL Server and learn the essential rank functions to optimize your database. Get tips and tricks you can use immediately to maximize your SQL Server performance!
SQL Bulk Insert And Update Records Using Stored Procedures
1/5/2023 11:11:18 AM.
Today we will learn how to insert and update multiple records using single stored procedure and user defined table type
What are the Differences Between SQL Server Stored Procedures and Functions?
12/24/2022 4:32:27 PM.
This article explains the difference between functions and stored procedures used in SQL Server.
Stored Procedures Vs User Defined Functions And Choosing Which One To Use
12/20/2022 10:41:02 AM.
In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply function
Using Stored Procedures With ASP.NET
12/7/2022 4:26:58 PM.
This article helps you to create a stored procedure in SQL Server and learn how to use a stored procedure in an ASP.NET application.
ORM Vs Stored Procedures In Programming
8/10/2022 10:38:58 PM.
In this article, you will learn about ORM vs Stored Procedures in Programming.
Customize Swagger UI In ASP.NET Web API Restful Service
6/22/2022 9:07:35 AM.
Swagger UI is very powerful documentation tool for Restful services so lets learn how we can implement and customize in Web API Restful service.
Implement Swagger UI In ASP.NET Web API Restful Service For Documentation Using Swashbuckle
2/28/2022 1:23:02 PM.
Swagger basically is a framework for describing, consuming, and visualizing RESTful APIs. The nice thing about Swagger that it is really keeps the documentation system, the client, and the server code
How to Use Ping in C#
1/31/2022 9:35:32 AM.
Whether it is a Web Server or any local computer, if you really want to check its availability then there is a way to do it. A common way to do this is PING.
Creating Stored Procedures With Entity Framerwork
3/26/2021 9:48:41 AM.
This article explains how to create Stored Procedures with Entity Framerwork.
Working With Stored Procedures Using Entity Framework: Part 3
3/25/2021 5:50:30 AM.
This article describes how to work with Stored Procedures using the Entity Framework in an ASP .Net Web Forms Application.
Working With Stored Procedures Using Entity Framework: Part 2
2/5/2021 7:44:10 AM.
This article describes how to use the Entity Framework code in the Web Forms Project Template and do the CRUD Operations.
Stored Procedures With Entity Framework
12/30/2020 7:21:58 AM.
Here we will understand Stored Procedures in EntityFramework.
Working With Stored Procedures Using Entity Framework: Part 1
11/27/2020 1:48:24 AM.
This article describes how to work with Stored Procedures using the Entity Framework in the ASP.NET Class Library.
Data Access Layer to execute Stored Procedures
11/3/2020 1:03:35 AM.
This article explains about executing a single stored procedure or batch of stored procedures from the application layer. As Data access layer completely decoupled from Application layer we just need
Inserting & retrieving images from SQL Server database using stored procedures
10/30/2020 5:29:45 AM.
In this article we will see how to insert & retrieve images from SQL server database using stored procedures.
Real Life SQL and .NET: Part V
10/30/2020 4:33:05 AM.
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be req
Stored Procedures In Azure Cosmos DB
7/16/2020 2:52:55 AM.
There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures
How To Build Server Side Objects Like UDF, Stored Procedure, & Trigger In Cosmos DB
7/13/2020 5:47:24 AM.
In this article, we will discuss the UDF, Stored Procedures, and Triggers in Cosmos DB.
Calling Oracle stored procedures from Microsoft.NET
5/15/2020 2:16:24 AM.
This article is intended to illustrate how to illustrate how to call Oracle stored procedures and functions from Microsoft.NET through the Microsoft.NET Oracle provider and its object model residing i
Rethinking Sorting In SQL Server Stored Procedures
2/4/2020 7:25:27 AM.
In this article, you will learn how to sort in Stored Procedures
Export Tables and Stored Procedures in SQL Server
8/18/2019 6:12:53 PM.
This article shows how to export or import tables and procedures from one SQL Server database to another SQL Server database.
Temporary Stored Procedures in SQL Server
7/18/2019 12:15:48 AM.
In this article, I highlight a small feature of Temporary Stored Procedures in SQL Server. Temporary Stored Procedures are similar to normal Stored Procedures, and are two kinds of temporary Stored Pr
Diference Between Stored Procedures And Functions
7/8/2019 9:00:43 PM.
In this article, I will discuss the difference between Stored Procedures and Functions and their usage.
Handling Errors within Stored Procedures in SQL Server
7/4/2019 2:56:14 AM.
This article discusses the @@ERROR, SP_ADDMESSAGE, and RAISERROR functions within SQL Server.
Some Useful System Stored Procedures in SQL Server 2012
7/2/2019 6:30:16 AM.
This article provides a brief introduction to various system Stored Procedures in SQL Server.
Stored Procedure Vs Function in SQL Server
6/3/2019 5:39:25 AM.
This article explains what stored procedures and functions are and how they work and some basic differences among them.
Execute Stored Procedures In MVC Core Using Entity Framework Core
4/23/2019 8:29:29 AM.
In this article, you will learn how to execute stored procedures in MVC Core using Entity Framework Core.
T/SQL - Stored Procedures and Functions - Part Three
9/17/2018 11:08:11 PM.
In this Article we Learn about store procedures and User Defined Function in SQL Server with Example.In previous article,we discussed about T/SQL and Cursor.
How To Create Four Types Of CLR Database Procedures In Visual Studio In C#
6/1/2018 8:28:01 AM.
In this article, we will learn about CLR database procedures in C#. Let’s discuss CLR database stored procedure.
An Overview Of CLR Database Procedures In C#
5/31/2018 11:39:49 PM.
In this article, we will learn about CLR database procedures in C#. Let’s discuss CLR database stored procedure.
Stored Procedures In Entity Framework 6 In MVC 5
11/8/2017 5:20:51 AM.
This article describes the use of Stored Procedures in an ASP.NET MVC Applications using the Entity Framework Code First Approach in Visual Studio 2013.
Find Out Creation And Modification Date Of Database Objects Like Tables And Stored Procedures
9/7/2017 2:01:32 PM.
Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
How To View LINQ To SQL Generated SQL Queries And Using Stored Procedures With LINQ To SQL
1/2/2017 8:51:02 AM.
In this article, you will learn how to view LINQ to SQL generated SQL queries and use stored procedures with LINQ to SQL.
Developing Book My Seat Application In AngularJS And ASP.NET- Part Three
10/14/2016 12:04:53 PM.
In this article, you will learn how to develop Book My Seat Application in AngularJS and ASP.NET.
CRUD Stored Procedures In SQL Server And Visual Studio
6/6/2016 5:38:04 AM.
In this article you will learn how to perform CRUD operations with Stored Procedures in SQL Server and Visual Studio.
Stored Procedures In ASP.NET MVC
12/22/2015 12:38:08 PM.
In this article, we are going to implement Create, Retrieve, Update, and Delete (CRUD) operations using stored procedures in ASP.NET MVC 4.0.
Send Email In SQL Server
9/8/2015 1:04:32 PM.
In this article you will learn how to send an email in SQL Server using few stored procedures.
Execution Process of Stored Procedure
7/29/2015 6:19:47 PM.
This article explains the execution process of Stored Procedures in depth.
Some Interesting Facts and Applications in SQL Server - Part 1 (Stored Procedures)
7/5/2015 3:07:00 AM.
This article provides interesting facts about Stored Procedures in SQL Server.
Stored Procedure Practices in SQL Server
7/3/2015 4:38:12 PM.
This article explains when to choose Stored Procedures, what is to be considered when creating a Stored Procedure with a template and also the definition of a sample Stored Procedure.
Useful MS-SQL Server System Stored Procedures
2/18/2015 4:01:55 PM.
In this article you will learn useful MS-SQL Server System Stored Procedures.
Introduction to Dynamic Data Web Application Model: Part VI
9/5/2014 5:13:52 AM.
This article explains about interfacing Stored Procedures and Dynamic Data Entities Web Application template.
SQL Server Stored procedures and UDF within LINQ context-PartII
9/4/2014 4:56:29 AM.
In the first article, SQL Server Stored procedures and UDF within LINQ context-Part I, I exposed 2 scenarios of how to deal with stored procedures using LINQ, in this second part, I will accomplish the task by demonstrating how to call a user defined function UDF using the same way adopted in the first part.
SQL Server Stored procedures and UDF within a LINQ context-Part I
9/4/2014 3:28:40 AM.
In this two parts particle, I will give techniques of how to deal with stored procedures and user defined functions UDF from within a LINQ context rather than ADO.Net.
Mapping Stored Procedures and Getting Multiple Records From Stored Procedures Using Dapper
8/28/2014 1:17:25 PM.
In this article you will learn how to get multiple records from Stored Procedures using Dapper.
LINQ to SQL in C#
3/28/2014 3:18:15 PM.
This article provides an introduction to employing LINQ to SQL within a Windows Forms application; the article will address the incorporation of LINQ to SQL into a win forms project, how to use LINQ to SQL to select, insert, update, and delete data, and how to use LINQ to SQL to execute stored procedures.
Count the Number of Tables, Stored Procedures, Triggers, Functions, Views in Your Database
3/19/2014 1:45:16 PM.
In this article I show how to determine how many types of entities you have in your any database.
Natively Compiled Stored Procedures in SQL Server 2014
3/6/2014 12:51:36 PM.
This article describes Natively compiled stored procedures (T-SQL procedures compiled to native code and access memory optimized tables) and their use.
In-Memory OLTP in SQL Server 2014
7/14/2013 1:27:26 PM.
This article explains how to work with In-Memory OLTP in SQL Server 2014.
Update Data With Stored Proc Using XSD (Typed Dataset)
11/16/2012 10:07:48 AM.
Today, in this article let’s play around with one of the interesting and most useful concepts in C#.
Using LINQ to SQL in Visual Basic
11/9/2012 7:04:48 AM.
This article provides an introduction to employing LINQ to SQL within a Windows Forms application.
Data Access Component for SQL Server in C#
10/20/2012 3:20:22 AM.
The attached source code a data access component for SQL Server that contains methods to get a DataSet.
The "ins" and "outs" of Using Stored Procedures in C#
10/20/2012 3:14:36 AM.
This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
Using Stored Procedures in Conjuction with DataAdapter
10/20/2012 3:09:35 AM.
A stored procedure is a named collection of SQL statements that are stored in the database. To the client a stored procedure acts similar to a function.
Stored Procedures in SQL
6/10/2012 7:34:54 AM.
In this article we are going to discuss Stored Procedures.
Understanding Database Stored Procedures
5/20/2012 4:48:50 AM.
This article discusses basics of stored procedures and how to create, update, and delete stored procedures in a database.
Using Table Variables Instead of Temporary Tables in SQL Server
5/20/2012 2:53:56 AM.
This article demonstrates how to use Table variables in SQL Server instead of temporary tables.
What are the Differences Between Stored Procedures and Functions?
5/19/2012 6:52:11 AM.
Here we see the differences between Stored Procedures and Functions.
How to Execute Oracle Stored Procedures Dynamically in C#
5/13/2012 8:15:46 AM.
In this article, I wiil show how we can store schema of stored procedures in an XML file and load and run the stored procedure from UI application using C# and Oracle.
CRUD Operations With Stored Procedures Via Entity Data Model Framework (EDM)
2/27/2012 4:28:07 AM.
Today, in this article let’s play around with one of the good interesting features, stored procedures with EDM Framework.
Build Reports using Crystal Reports and Stored Procedures
2/11/2012 11:18:00 AM.
In this article, you will see how to get data using a stored procedure and build reports in Visual Studio and Crystal Reports.
Simple Login Project Using Stored Procedures in ASP.NET: Part 2
6/8/2011 3:13:53 PM.
This article will discuss how to take advantage of stored procedures in a login project.
Simple Login Project using Stored Procedures in ASP.NET: Part 1
6/8/2011 3:08:38 PM.
This article will discuss how to take advantage of a stored procedure in a login project.
Working with Entity Data Model and Executing Stored Procedures
6/21/2010 1:48:09 AM.
In this article we are going to work with the following concepts that EDM support.
Creating Stored Procedures with Managed Code
4/8/2010 2:44:41 AM.
This article is intended to illustrate how to implement a stored procedure with managed code.
working with Stored Procedures
3/3/2010 11:39:27 PM.
In this article I will explain working with Stored Procedures.
Using partial class, when working with LINQ to SQL Stored Procedures
7/30/2009 7:55:30 AM.
In this article I will explain how you can combine using of your own classes to DataContext (dbml file) and partial DataContext class, when working with LINQ to SQL Stored Procedure.
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 3
6/22/2009 12:31:27 AM.
This is the third in a series of columns in which I will tell you how I started SplendidCRM Software, Inc.
Executing multiple stored procedures within a single transaction context from ADO.Net
3/20/2008 1:37:44 AM.
This article discusses how we can execute multiple stored procedures in ADO.NET with different parameter values in a single Transaction context.
Real Life SQL and .NET: Part II
2/8/2006 5:55:26 AM.
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.