Here Mudassar Ahmed Khan has explained with an example, how to convert (select) Date in dd/MM/yyyy format in SQL Server.

This article will illustrate how to use Stored Procedures for converting Dates in dd/MM/yyyy format.

Here Mudassar Ahmed Khan has explained with an example, what is DATEFORMAT command in SQL Server, why it is used and also an example which helps understanding the DATEFORMAT command in better way.

Here Mudassar Ahmed Khan has explained with an example, how to insert and select Date in dd/MM/yyyy format in DateTime Column of SQL Server database.

This article will illustrate how to use Stored Procedures for inserting and selecting Dates in dd/MM/yyyy format.

Here Mudassar Ahmed Khan has explained with an example, how to read, parse and insert XML File data to SQL Server Table using Stored Procedure.

SQL Server 2005 and above versions, allow to read and parse and XML file using the XML data type and it also provide functions to parse the XML and extract its Attribute and Tag values.