SQL is an essential language for you if you are developing data-driven applications. This post will bring you Microsoft SQL tricks that many of you might not have thought were possible. 1. Limit length of text: Use this to cut short a longer text and limit the result to specified number of characters ('Description' is your column name): SELECT ...