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 …
Dear Friends, Sometimes we get task like, we need to import data in a target table from a source table and the condition is that the data which we are going to import should not exist in target table . To achieve this we have two ways 1) Left outer join 2) Except clause …