table Aliasing

An interesting way of aliasing TIP#107

I recently gone through something and found a unique way of aliasing. I thought it must be share so other techies also aware of it (or might be you already aware of it). See below example SELECT *FROM (VALUES (‘Rajat’,30),             (‘Sandeep’,40),             (‘Sunil’,35),             (‘Shreya’,50),             (‘Virendra’,45)) AS T(Name,Runs) Now when you it  you will get following result …

Proper Aliasing will help you somewhere TIP#104

Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I thought this might be question in everyone’s mind. So lets start with couple of well know statements then we will see the actual problem where we need it explicitly. There are two type of aliasing …