Most Important SQL Server Interview Questions and Answers

Introduction: In this article i am going to explain frequently asked top most  important  sql server interview questions and answers. Th...

SQL SERVER: Convert Table Data to XML Format using FOR XML PATH()

Introduction : In this article I am going to explain how to convert sql table data to different xml format using FOR XML PATH().    In...

SQL SERVER: How to Replace XML Node's Attribute Value in XML Column of Table

Introduction :   In this article i am going to explain how to update the value of XML node's attribute in XML data type column in all ...

SQL SERVER: Searching XML Node's Attribute Value Exists or Not in XML Datatype Column of Table

Introduction : In this article i am going to explain how to find all or specific records in sql table where the xml node's attribute v...

Sql Server: User Defined Function to Get All Dates Between Two Dates

Introduction : In this short article I am going to share how to create a table valued user defined function to get all dates between speci...

Sql Server: Using CTE to Get All Dates Between Two Specified Dates

Introduction : In this short article I am going to share how to get all dates between the date range we specify in Sql server using CTE (C...