Useful T-SQL Queries for SQL Azure

SQL Azure is a Platform-as-a-Service (precisely Database-as-a-Service) and it is used as a database hosted and managed by Microsoft Azure. There is difference between SQL Server and SQL Azure in terms of T-SQL queries.
This blog post would give some quick reference for the T-SQL queries which are used frequently