Category - Stored Procedures
Results 11 - 15 of 49
14 Jun 2018 14 Jun 2018 0 Comments  1904 Views
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.
14 Jun 2018 14 Jun 2018 0 Comments  1086 Views
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.
14 Jun 2018 14 Jun 2018 0 Comments  20808 Views
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.
21 May 2018 21 May 2018 0 Comments  8255 Views
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.
21 May 2018 21 May 2018 2 Comments  6004 Views
Here Mudassar Ahmed Khan has explained with an example, how to read, parse and insert XML String data to SQL Server Table using Stored Procedure.

SQL Server 2005 and above versions, allow to pass a parameter of XML data type to the Stored Procedure and provide functions to parse the XML and extract its Attribute and Tag values.
Results 11 - 15 of 49