I'm gonna start working in SQL Server, But many of our Oracle Functions are not Supported in MsSQL. For Example, 1. No "For Loop" in SQL Server, because of which I've to add one column and increment it to finish the loop which is more tedious.. 2. No "Level" fucntion for achieving sample data generation and Process using loop in query itself, 3. No "To_date", "To_Char" function, but seperate code for converting into seperate formats.. So far, I've faced these functions which are incompatible in MsSQL. Could anyone who are Good at SQL server too, can help me by providing some tips how you handled these kind of conversions Intially..? I asked 1 of my Friend, who's a SQL server Guy, he told me to code in accordance with ANSI Standards. So, that means the above mentioned Oracle Functions doesn't comes under ANSI Standards?! If that so, could you help me with the materials having functions which are Universally Compatible(for All DataBases). Please Advise.