Category - Stored Procedures
Results 61 - 73 of 73
03 Apr 2015 03 Apr 2015 0 Comments  17321 Views
Here Mudassar Ahmed Khan has explained with example the syntax to drop a Stored Procedure in SQL Server i.e. how to delete a Stored Procedure in SQL Server.
Using this tutorial you can easily delete (Drop) an existing Stored Procedure in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.
03 Apr 2015 03 Apr 2015 0 Comments  37709 Views
Here Mudassar Ahmed Khan has explained a tutorial with example on how to modify (Alter) an existing Stored Procedure in SQL Server.
Using this tutorial you can easily modify (Alter) an existing Stored Procedure in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.
23 Jan 2015 23 Jan 2015 2 Comments  41905 Views
Here Mudassar Ahmed Khan has explained how to call Stored Procedure with parameters in Entity Framework using C# and VB.Net.
24 Dec 2014 24 Dec 2014 0 Comments  55234 Views
Here Mudassar Ahmed Khan has explained how to call and execute a SELECT Stored Procedure with parameters in Entity Framework in ASP.Net using C# and VB.Net.
The parameter value will be passed to the SELECT Stored Procedure and it will return multiple records using Entity Framework model in C# and VB.Net.
02 Dec 2014 07 Dec 2020 8 Comments  100183 Views
Here Mudassar Ahmed Khan explained how to pass comma separated (delimited) values as Parameter to Stored Procedure in SQL Server.

The comma separated (delimited) values will be split into Table rows and will be used for querying inside the SQL Server Stored Procedure.
05 Nov 2014 05 Nov 2014 20 Comments  302782 Views
Here Mudassar Ahmed Khan has explained how to perform select, insert, edit, update, delete in GridView using a single Stored Procedure in ASP.Net using C# and VB.Net.

This process is also known as CRUD i.e. Create, Read, Update and Delete in GridView using Stored Procedure with SQL Server database backend in ASP.Net.
18 Sep 2014 07 Dec 2020 3 Comments  73695 Views
Here Mudassar Ahmed Khan explained how to insert comma separated / delimited values in a table in SQL Server using Split function.
18 Sep 2014 07 Dec 2020 5 Comments  198300 Views
Here Mudassar Ahmed Khan explained how to split and convert a comma separated / delimited string to a table in SQL Server using Split function.
08 Sep 2014 07 Dec 2020 4 Comments  325937 Views
Here Mudassar Ahmed Khan has shared with an example, a function to split a string in SQL Server 2005, 2008 and 2012 versions. The string containing words or letters separated (delimited) by comma will be split into Table values.

He has also explained how to use the Split function to split a string in a SQL Query or Stored Procedures in SQL Server 2005, 2008 and 2012 versions.
12 Jun 2014 15 Oct 2020 13 Comments  152525 Views
Here Mudassar Ahmed Khan has explained with an example, how to send (pass) DataTable as parameter to Stored Procedure using the SQL Server User Defined Table Type in ASP.Net with C# and VB.Net.

The User Defined Table Type has to be created in SQL Server and it must have the same schema as that of the DataTable that we need to pass to the Stored Procedure as parameter in ASP.Net with C# and VB.Net.
18 Jan 2011 04 Sep 2021 18 Comments  170230 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Custom Paging in ASP.Net GridView control using C# and VB.Net.

Custom Paging in GridView will be implemented with the help of Stored Procedure in ASP.Net using C# and VB.Net.
13 May 2009 15 Oct 2020 2 Comments  122524 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table name dynamically to a query or stored procedure in SQL Server.

The sp_executesql command supports accepting Table name as Parameter (Variable) in the following SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014, 2017, 2019 and higher.
09 May 2009 27 Nov 2021 4 Comments  517545 Views
Here Mudassar Ahmed Khan has explained with an example, how to get Column names from a Database table in SQL Server.

This article will discuss two methods to get Column names from a Database table:
1. Using SQL Query
2. Using Stored Procedure
Results 61 - 73 of 73