Day 5 – Peer Identity

This is the fifth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 5 – Peer Identity

This is the fifth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

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...

Day 4 – Broken Broker

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 4 – Broken Broker

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

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...

Being a Better IT Pro - Grammar

In my IT career, one of the things I have found that sets me apart is my ability to write....

Day 3 – Reviewing Peers

This is the third installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 3 – Reviewing Peers

This is the third installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...