Category - SQL Server
Results 1 - 10 of 73
18 Sep 2014
0 Comments   111 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
0 Comments   89 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
0 Comments   743 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.
23 Aug 2014
0 Comments   770 Views
Here Mudassar Ahmed Khan has explained how to populate or bind TreeView from database in ASP.Net using C# and VB.Net.
22 Aug 2014
0 Comments   649 Views
Here Mudassar Ahmed Khan has explained how to pass XML file as parameter to Stored Procedure in C# and VB.Net.
11 Aug 2014
0 Comments   1462 Views
Here Mudassar Ahmed Khan has explained how to save image as binary data into SQL Server database and also how to retrieve and convert the image back to their respective formats using C# and VB.Net.
11 Aug 2014
0 Comments   1102 Views
Here Mudassar Ahmed Khan has explained how to save file as binary data inside SQL Server database and also how to retrieve them and convert them back to their respective formats using C# and VB.Net.
10 Aug 2014
0 Comments   1580 Views
Here Mudassar Ahmed Khan has explained how to upload and insert XML file data using Stored Procedure in ASP.Net using C# and VB.Net.

SQL Server 2005 onwards we can pass a parameter of XML data type to the Stored Procedure and also we can easily parse the XML and extract its attribute and Inner Text of tags.
05 Aug 2014
0 Comments   1158 Views
Here Mudassar Ahmed Khan has explained how to pass multiple records (rows) to a Stored Procedure in SQL Server using C# and VB.Net.
We can pass a Table containing multiple records (rows) to a Stored Procedure by making use of Table Valued parameters in SQL Server.
29 Jul 2014
0 Comments   1919 Views
Here Mudassar Ahmed Khan has explained how to populate (bind) TreeView control with Nodes having Parent Child relationship from database in ASP.Net using C# and VB.Net.

The TreeView will be populated using recursion.