Category - Stored Procedures
Results 41 - 60 of 73
22 May 2016 22 May 2016 0 Comments  124608 Views
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 04 Feb 2016 0 Comments  16375 Views
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 29 Jan 2016 0 Comments  112752 Views
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 29 Jan 2016 1 Comments  77880 Views
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 29 Jan 2016 0 Comments  60278 Views
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 0 Comments  15174 Views
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 06 Nov 2015 1 Comments  11470 Views
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 0 Comments  28702 Views
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 0 Comments  43584 Views
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 02 Nov 2015 9 Comments  244203 Views
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 30 Oct 2015 1 Comments  65024 Views
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 0 Comments  18689 Views
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 15 Aug 2015 0 Comments  58934 Views
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 20 Jul 2015 1 Comments  109055 Views
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 19 Jul 2015 0 Comments  89433 Views
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 14 Jul 2015 0 Comments  12966 Views
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 25 Jun 2015 2 Comments  156789 Views
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 0 Comments  13763 Views
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 21 Apr 2015 1 Comments  96207 Views
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 03 Apr 2015 2 Comments  112923 Views
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.
Results 41 - 60 of 73