Category - Stored Procedures
Results 1 - 5 of 24
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.
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.
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.
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.
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.
Results 1 - 5 of 24