Category - Stored Procedures
Results 16 - 20 of 56
14 Jun 2018 14 Jun 2018 0 Comments  1547 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  45059 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  14573 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  11212 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.
21 Apr 2018 21 Apr 2018 0 Comments  2063 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform Search in Entity Framework without using LINQ with C# and VB.Net.
Results 16 - 20 of 56