Category - SQL Server
Results 1 - 5 of 109
05 May 2015
0 Comments   569 Views
Here Mudassar Ahmed Khan has explained how to convert binary data to PDF file and display in browser in ASP.Net using C# and VB.Net.
05 May 2015
0 Comments   426 Views
Here Mudassar Ahmed Khan has explained with example, how to read binary data files and convert them to their respective file formats and write the files as binary data and save it to database.
23 Apr 2015
0 Comments   868 Views
Here Mudassar Ahmed Khan has explained how to create and drop (delete) SQL Server Table programmatically using ADO.Net, C# and VB.Net.

The Create and Drop script will be dynamically generated and the Table will be respectively created or deleted in SQL Server database.
22 Apr 2015
0 Comments   710 Views
Here Mudassar Ahmed Khan has explained with an example, what is Stored Procedure in SQL Server, how to create (write) and use a Stored Procedure and finally the advantages of using Stored Procedure in SQL Server.

Stored Procedures are compatible in all SQL Server versions namely 2000, 2005, 2008, 2008R2, 2012 and 2014.
21 Apr 2015
0 Comments   632 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the SQL Server COALESCE function to get comma separated (delimited) values from Table in SQL Server.
COALESCE function can be used to get comma separated (delimited) values from Table in the following SQL Server versions i.e. 2005, 2008, 2008R2, 2012 and 2014.
Results 1 - 5 of 109