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...

Sql Server: Get Created or Modified Date of Tables, Stored Procedures, Views and Functions

Introduction :   In this article I am going to share how to know when a table, stored procedure, views or user defined function (scalar or...

Sql Server: How to Parse XML and Get Data as Comma Separated String Format

Introduction : In this article I am going to explain how to get comma separated values from xml data in sql server using two suitable exam...

How to Read or Parse XML Data and Insert into SQL Table

Introduction : In this article I am going to explain how to parse xml to read data and store that data in sql server table, temporary tabl...