SQL Tips & Tricks

Use this forum to post your tips & tricks concerning SQL. Please start a new thread for every new tip/trick. Do not ask questions in this forum. Incorrect postings will be removed.