Answer - Question of the Week - 28/12/2013 - Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...

While loop in SQL server

In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....

Happy New Year 2014

                              HAPPY NEWYEAR2014

Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my...

Deleting Duplicate rows using CTE

Many times we caught in a situation where we have a table where there is no primary or unique column...

Answer -Question of the Week - 25/12/2013- Question 1

Question:- Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it...

Question of the Week - 28/12/2013 - Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...

Question of the Week -25/12/2013- Question1

Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it contains...

Ranking Functions in SQL Server

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition....

Case Statement/ Expression in SQL Server

Case Statement/ Expression in SQL server 
 
Sometimes we need to get one result output from multiple possible outcomes based on the...

Stuff VS Replace function in SQL Server

Stuff function: - This function is used to replace string from the given start position, passed as 2nd argument with string...