Vivek's SQL Notes
Archives: December 2013
Happy New Year 2014
HAPPY NEW YEAR 2014
0 comments, 815 reads
Posted in Vivek's SQL Notes on 31 December 2013
Deleting Duplicate rows using CTE
Suppose we…
0 comments, 43,412 reads
Posted in Vivek's SQL Notes on 29 December 2013
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 contains the following data:-
Studentid Studentname
1 Vivek Johari
2 Chandra Singh
4…
1 comments, 658 reads
Posted in Vivek's SQL Notes on 28 December 2013
Question of the Week - 28/12/2013 - Question 2
9 comments, 469 reads
Posted in Vivek's SQL Notes on 28 December 2013
Question of the Week -25/12/2013- Question1
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it contains the following data:-
Studentid Studentname
1 Vivek Johari
2 Chandra Singh
4…
14 comments, 428 reads
Posted in Vivek's SQL Notes on 25 December 2013
Ranking Functions in SQL Server
0 comments, 7,594 reads
Posted in Vivek's SQL Notes on 25 December 2013