Happy New Year 2014
HAPPY NEW YEAR 2014 Wishing […]
Happy New Year 2014 Read Post »
December 2013
Deleting Duplicate rows using CTE
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is
Deleting Duplicate rows using CTE Read Post »
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
Answer -Question of the Week – 25/12/2013- Question 1 Read Post »
Interview Questions
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
Question of the Week – 28/12/2013 – Question 2 Read Post »
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))
Question of the Week -25/12/2013- Question1 Read Post »
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.
Ranking Functions in SQL Server Read Post »
You must be logged in to post a comment.