If you look at a QWERTY keyboard, you'll see this is a splendid example of the well known "off by one" error. 😉

1. Bit is an exact numeric per link cited above.

2. Bit can't even hold a negative value.

3. There are no data types smaller than bit.

Thus, the correct answer should be...

How about neither? Right now I'm in a position where database admin and development was the initial focus. But, I got things pretty much under control after not too long....

paul.knibbs (5/2/2014)

---

Is it? I can't recall a situation where I've actually used this facility, although I knew the correct answer...would be...

david.gugg (5/2/2014)

---

I'm sure I'm in the minority with my perspective. I love SQL Server - learning how it works, why it does what it does, how to make it...

OCTom (4/30/2014)

---

Thomas Abraham (4/30/2014)

---

BWFC (4/30/2014)

It certainly has its uses but I'm always careful what I post because unscrupulous types could use it to bypass the hours of research that I...

BWFC (4/30/2014)

It certainly has its uses but I'm always careful what I post because unscrupulous types could use it to bypass the hours of research that I may have been...

Kind of disturbing to see that 36% (as of now) think a checkpoint is taken after every completed transaction.

--------------

That was easy!

(1 row(s) affected)

Understand the basics, the theory that underlies the practical. And don't get married to a particular technology/programming language/vendor. However, if you do, then be the very best at it. (And...

stephen.long 56048 (4/15/2014)

---

Good question, Steve. It made me do some research, since I haven't used encryption yet professionally. I did notice a few minor errors: the field name should have...

I tend to interpret this as living up to YOUR commitments. Others have spoken about living up to OTHER's commitments. And that always sucks. I've had plenty of incompetent managers...

Ugh, Monday and not enough coffee yet. Thanks for the question.

Nevyn (4/10/2014)

---

venoym (4/10/2014)

---

Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string...

pmadhavapeddi22 (4/3/2014)

---

when we are specifying high range of rows nearing to the exact no of rows then it will return all the rows of the table

like , in the QOD

we...