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

How to Convert XML Data to SQL Database Table

Introduction : In this article I am going to explain how to select or convert xml data to sql table format. In previous articles i exp...

Sql Server Query to find all foreign keys referring to particular table

Introduction :   In this article I have explained How to get all foreign keys that refers to a particular table in sql server. I.e. listin...

Sql Server: CTE Recursive Query to Get Employee Manager Hierarchy with Level

Introduction : In this article I have explained How to get parent child hierarchical relationship with levels using CTE (Common Table Expr...

Sql Server: Query to get string between two characters or symbols

Introduction : In this article I am going to share the query to extract substring from within two special characters or symbols in sql ser...

Sql Server: Drop or Truncate Parent Table by Dropping All Foreign Key Constraints

Introduction :  Here in this article you will learn the following: How to find all foreign key constraints names and child tables refe...

Sql Server: Add or Subtract Days, Weeks, Months, Quarters and Years in/from Date

Introduction : In this article I am going to explain How to add or subtract d ays, weeks, months, quarters and years in/from any date in S...

Sql Server Query to Search any Text in All Stored Procedures, Views and Functions

Introduction : In this article I am going to explain How to find any text/string in all stored procedures or views or user defined functio...

Search Particular Column in all Tables or Views in Sql Server Database

Introduction : In this article I have explained How to find all tables or views in sql server database that contain a specific column. Or ...

Sql Server: Query to Get Age in Years, Months and Days from Date of Birth

Introduction : In this article I am going to explain how to calculate age in year, month and day from the Date of birth(DOB) field. I...

Sql Query to Get First, Last Date and Total Days in Year or Month

Introduction : In this article I am going to share how to find first and last day of the year or month and count the total number of days ...

SQL Server Query to Get Upcoming Birthdays Within Week

Introduction : In this article I am going to explain How to get the birthday of employees falling within week from current date. In pr...