Category - SQL Server
Results 1 - 5 of 125
20 Jul 2015
0 Comments   719 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
0 Comments   701 Views
Here Mudassar Ahmed Khan has explained with an example, how to display and change image in Image control based on DropDownList selection in ASP.Net using C# and VB.Net.
When DropDownList selection is changed, the images stored as Binary data will be fetched as BYTE Array and then the BYTE Array will be converted to BASE64 string and then assigned to the ASP.Net image control.
17 Jul 2015
0 Comments   476 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind / fill/ populate DataTable from Database in ASP.Net using C# and VB.Net.
14 Jul 2015
0 Comments   415 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.
13 Jul 2015
0 Comments   393 Views
Here Mudassar Ahmed Khan has explained with an example, the similarities and differences between LEN and DATALENGTH functions in SQL Server.
Both LEN and DATALENGTH functions as the name suggest are used to determine lengths, though they have some similarities they are still different from each other and have their own specific usage.
This article is applicable to SQL Server versions 2005, 2008, 2008R2, 2012, 2014 and higher.
Results 1 - 5 of 125