Stored Procedures Articles

Category - Stored Procedures

22 May 2016 Mudassar Khan 0 Comments 124608 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has provided a simple Cursor tutorial with Syntax example in SQL Server.
Cursor is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.

04 Feb 2016 Mudassar Khan 0 Comments 16375 Views

ASP.Net Repeater Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) Repeater control using Stored Procedure in ASP.Net using C# and VB.Net.
Repeater will be populated using Stored Procedure in SQL Server database and will be displayed as HTML table on the page.

29 Jan 2016 Mudassar Khan 0 Comments 112752 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to return value True if record exists and value False when record does not exist from Stored Procedure in SQL Server.
In order to return value the EXEC function will be used. The value will be returned as 1 (True) if record exists and 0 (False) is record does not exists.
Using the EXEC function returning value of a Stored Procedure to a variable is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.

29 Jan 2016 Mudassar Khan 1 Comments 77880 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to execute a Stored Procedure that Returns value and assign its returned value to a variable in SQL Server.
Using the EXEC function returning value of a Stored Procedure to a variable is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.

29 Jan 2016 Mudassar Khan 0 Comments 60278 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to return result value of EXEC function and save it to a variable in SQL Server.
The EXEC function supports returning value to a variable is supported in SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.

09 Nov 2015 17 Jul 2021 Mudassar Khan 0 Comments 15174 Views

ASP.Net SQL Server GridView SqlDataSource Stored Procedures

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

In this article GridView will be populated and filtered using a StoredProcedure and SqlDataSource.

06 Nov 2015 Mudassar Khan 1 Comments 11470 Views

ASP.Net GridView Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) GridView using StoredProcedure and SqlDataSource in ASP.Net.

05 Nov 2015 28 Jul 2021 Mudassar Khan 0 Comments 28702 Views

ASP.Net SQL Server GridView Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to search database records using Stored Procedure and display the results using GridView control in ASP.Net.

04 Nov 2015 28 Jul 2021 Mudassar Khan 0 Comments 43584 Views

ASP.Net SQL Server GridView SqlDataSource Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to use StoredProcedure with SqlDataSource and how to pass values to parameters of 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 Nov 2015 Mudassar Khan 9 Comments 244203 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has provided a tutorial with simple example that explains how to use Cursor in SQL Server Stored Procedures. Cursor is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.

30 Oct 2015 Mudassar Khan 1 Comments 65024 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to use LIKE operator (statement) in Stored Procedures with SQL Server database.
In Stored Procedures, the LIKE operator (statement) is used with the Stored Procedure parameters.

17 Aug 2015 15 Oct 2020 Mudassar Khan 0 Comments 18689 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to pass Table name as Parameter (Variable) to sp_executesql command 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.

15 Aug 2015 Mudassar Khan 0 Comments 58934 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to execute (run) Stored Procedure in SQL Server Management Studio.
The Stored Procedure can be easily called (executed) using the EXEC command in SQL Server Management Studio.
This method works for all versions for SQL Server Management Studio editions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher including SQL Server Management Studio Express editions.

20 Jul 2015 Mudassar Khan 1 Comments 109055 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to perform Select, Insert, Update and Delete operations using a single Stored Procedure in SQL Server.
Performing Select, Insert, Update and Delete operations using a single Stored Procedure is supported in SQL Server versions i.e. 2005, 2008, 2008R2, 2012, 2014 or higher.

19 Jul 2015 Mudassar Khan 0 Comments 89433 Views

ASP.Net Stored Procedures DataTable

Here Mudassar Ahmed Khan has explained with an example, how to load / fill/ populate DataTable from Stored Procedure in ASP.Net using C# and VB.Net.
The records returned from the Stored Procedure will be loaded into the DataTable using ADO.Net SqlDataAdapter in C# and VB.Net

14 Jul 2015 Mudassar Khan 0 Comments 12966 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to assign (set) result value of EXEC function to Variable in SQL Server.
The capturing and assigning result value from EXEC function to a variable is supported in SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.

25 Jun 2015 Mudassar Khan 2 Comments 156789 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained how to return Identity value from Stored Procedure in SQL Server.
The Identity value (ID value) of the newly (last) inserted record can be determined using @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT functions.
This article is applicable to SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014 versions.

12 Jun 2015 15 Oct 2020 Mudassar Khan 0 Comments 13763 Views

SQL Server Stored Procedures Table

Here Mudassar Ahmed Khan has explained with an example, how to pass Table as parameter i.e. Table Valued Parameters to Stored Procedure in SQL Server.

The User Defined Table Type has to be created in SQL Server and it must have the same schema as that of the Table Valued parameter that we need to pass to the Stored Procedure.

21 Apr 2015 Mudassar Khan 1 Comments 96207 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to return multiple values from a Stored Procedure in SQL Server.
Multiple values will be returned from Stored Procedure by returning comma separated (delimited) values using Output Parameter.

Output Parameter is supported in Stored Procedures of all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.

03 Apr 2015 Mudassar Khan 2 Comments 112923 Views

SQL Server Stored Procedures

Here Mudassar Ahmed Khan has explained with an example how to return value from a Stored Procedure in SQL Server. SQL Server allows to return a single integer value from a Stored Procedure using the RETURN keyword.
The Return keyword is supported in Stored Procedures of all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.