Insert same rows multiple times in table
Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table
Home »
sql server interview question
How to compare column names in two tables in SQL
In this article you will see how to compare column names in two table. Assume that, you have two tables and you are asked to… Read More »How to compare column names in two tables in SQL
Search string in xml
How to search for string within xml column in SQL table? As you can see here we have a sample table having categories and products… Read More »Search string in xml
Generate a range of numbers between two numbers in SQL Server
Sometimes, you need to show range of numbers or may be asked to generate a range of numbers between two numbers in SQL Server. Well,… Read More »Generate a range of numbers between two numbers in SQL Server
What is SubQuery in SQL ?
A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.