Happy New Year 2014
HAPPY NEW YEAR 2014 Wishing all of the readers of this blog a very happy New Year. Thanks for supporting…
HAPPY NEW YEAR 2014 Wishing all of the readers of this blog a very happy New Year. Thanks for supporting…
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is…
Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname…
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5…
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))…
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition.…