tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing about nice simple answers is that they're nice and simple to modify to your needs. 😉
There's a whole lot of power in the functions of any language. If I need to learn a new language, one of the first things I do is to check the documentation for all the functions to see what's available. Unfortunately, SQL Server no longer installs "Books Online" by default nor do they provide it. You either have to download it or set it up to look on the web. It's definitely worth doing either way.
--Jeff Moden
Change is inevitable... Change for the better is not.