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
6,117 total views, 9 views today
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
6,117 total views, 9 views today
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
10,834 total views, 24 views today
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
2,716 total views, 3 views today
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
9,449 total views, 7 views today
A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.
1,917 total views, 1 views today