A good article that explains the differences in T-SQL in Azure SQL Database