sgmunson (12/5/2016)

---

Jeff Moden (12/5/2016)

---

sgmunson (12/5/2016)

---

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. 😉

Hmmm.... are you really all that willing to claim you have room for that sized object in any particular body cavity? 😉

Heh... it's an occupational hazard. As we all know, every performance problem and process problem is the fault of the database and the SQL Server, right? DBAs get "bent over" like this every day. 😉

Sorry to hear that, my friend... but I do understand... However, if they start threatening to insert a book in a body cavity, it may be time to find a safer alternative. Or, take the book forcefully from the person trying to bend you over and go threaten the developer you know ACTUALLY caused the grief... with the same fate... 😉