Fun with dot

The symbol dot (.) plays a major role when you write queries. It is mainly used to speicify the columns for the respective tables when a join is used as you see in the following exampleselect t1.col1,t1.col2,t2.col3,t2.col4 from table1 as t1 inner join table1 as t2 on t1.col1=t2.col1But sometimes the usage of dot may surprise you. Let us consider the following examplecreate table #test(i int)