Jeff Moden (12/5/2016)

---

Lynn Pettis (12/5/2016)

---

Jeff Moden (12/3/2016)

---

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.

And if you are on a closed (or secured) network with no access to the Internet, looking things up on the Internet is nonstarter out the gate.

Absolutely agreed. It's a real pain. It's been a very long time since I had to work in such an installation but always made sure that the appropriate "Help" or even a hardcopy book was always available in such cases. And I always made sure they were the one's that provided it. I didn't want them to find a 9 x 7 X 2.5 book during a cavity search. 😉