Stored Procedures Articles

Category - Stored Procedures

24 Sep 2021 Mudassar Khan 0 Comments 5387 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to get Total Record Count (Row Count) of Table when Paging in Stored Procedure using Common Table Expression (CTE) in SQL Server.

24 Sep 2021 Mudassar Khan 0 Comments 2406 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to implement Paging in SQL Server Stored Procedure without using Temp Tables (Temporary Tables).

This article will illustrate how to write a Stored Procedure that does Paging using Common Table Expression (CTE) technique in SQL Server.

14 Sep 2021 Mudassar Khan 0 Comments 4017 Views

SQL Server Tips Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to write a Stored Procedure that does Paging using Common Table Expression (CTE) in SQL Server.

04 Sep 2021 Mudassar Khan 0 Comments 3750 Views

SQL Server Tips Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to write a Stored Procedure that does Paging along with Total Row Count in SQL Server.

This article will illustrate how to implement Paging in Stored Procedure using TEMP Tables in SQL Server.

11 Aug 2021 Mudassar Khan 0 Comments 15682 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC Web API

Here Mudassar Ahmed Khan has explained with an example, how to perform CRUD operation (Create, Read, Update and Delete) using Web API and Stored Procedure in ASP.Net MVC Razor using Entity Framework and jQuery AJAX.

The Stored Procedure will be called using Entity Framework to perform CRUD operations such as Select, Insert, Edit, Update and Delete operations.

17 Jul 2021 Mudassar Khan 0 Comments 1840 Views

ASP.Net SQL Server SqlDataSource Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to use the CancelSelectOnNullParameter property in ASP.Net SqlDataSource.

The CancelSelectOnNullParameter property is used to cancel the SELECT query i.e. return no result when a parameter is NULL.

17 Jul 2021 Mudassar Khan 0 Comments 4538 Views

ASP.Net SQL Server GridView SqlDataSource Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to use NULL Parameters with SqlDataSource and how to pass NULL parameters to StoredProcedure using SqlDataSource in ASP.Net.

In this article, a GridView will be populated and filtered using a StoredProcedure and SqlDataSource in ASP.Net.

02 Jun 2021 Mudassar Khan 0 Comments 21179 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to use Stored Procedure with parameters with Entity Framework Core Database First Approach in ASP.Net Core MVC.

Database First Approach means first the Database is configured and then it is connected to Application using Entity Framework Core.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework Core Framework in ASP.Net Core MVC.

19 May 2021 Mudassar Khan 0 Comments 8200 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to call Stored Procedure with parameters using Entity Framework in .Net Core 2.1.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework in .Net Core 2.1.

18 May 2021 Mudassar Khan 0 Comments 11714 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using Entity Framework in ASP.Net Core MVC.

The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net Core MVC.

07 Dec 2020 Mudassar Khan 0 Comments 20493 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to split a String into Rows in SQL Server.

This article will illustrate how to create a function that will split a string separated (delimited) by comma, space or some other special characters into Table Rows in SQL Server.

15 Oct 2020 Mudassar Khan 0 Comments 32384 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to execute Stored Procedure with Table Valued Parameters in SQL Server.

First a Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter.

Then it is passed as Parameter to the Stored Procedure and the Stored Procedure is executed using the EXEC command in SQL Server.

15 Oct 2020 Mudassar Khan 0 Comments 6946 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.

15 Oct 2020 Mudassar Khan 1 Comments 16747 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.

15 Oct 2020 Mudassar Khan 0 Comments 15610 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to pass TEMP Table as Parameter to Stored Procedure in SQL Server.

A TEMP Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.

20 Nov 2018 Mudassar Khan 0 Comments 27886 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC

Here Mudassar Ahmed Khan has explained with an example, how to insert (save) data (records) to database by calling Stored Procedure using Entity Framework in ASP.Net MVC Razor.

First the multiple rows (records) will be insert into an HTML Table and then the data from all the rows of the HTML Table will be sent to Controller using jQuery AJAX which will be ultimately saved to database by calling Stored Procedure using Entity Framework in ASP.Net MVC Razor.

05 Oct 2018 Mudassar Khan 0 Comments 31455 Views

ASP.Net SQL Server Stored Procedures MVC

Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) DropDownList using Stored Procedure in ASP.Net MVC Razor.

The records from the database will be fetched using Stored Procedure and populated into a Generic List collection of Model class objects and then will be saved into a ViewBag object.

Inside the View, the ViewBag object will be passed to the Html.DropDownList Helper function for populating the DropDownList in ASP.Net MVC Razor.

04 Oct 2018 Mudassar Khan 0 Comments 41342 Views

ASP.Net ADO.Net Excel SQL Server Stored Procedures OLEDB

Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database using Stored Procedure in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a folder on Server. Then using Stored Procedure and OLEDB, the data from Excel file will be read and imported into SQL Server Database Table.

07 Sep 2018 Mudassar Khan 1 Comments 36228 Views

SQL Server Stored Procedures Email Gmail Triggers

Here Mudassar Ahmed Khan has explained with an example, how to send Email from Trigger in SQL Server.

This article will illustrate how to send email from Trigger using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016 and 2017.

06 Sep 2018 Mudassar Khan 4 Comments 87501 Views

SQL Server Stored Procedures Gmail

Here Mudassar Ahmed Khan has explained with an example, how to send email in SQL Server using Stored Procedure.

This article will illustrate how to send email using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016 and 2017.