Stored Procedures Articles

Category - Stored Procedures

15 Oct 2020 Mudassar Khan 0 Comments 3232 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 7632 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 6357 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 23155 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 23239 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.