Seemed like both would return the same results. I just never use version two.

I agree with thottle, a HIPAA violation will help change things.

So I looked up the word "Favorite" and this is the definition it gave:

"preferred before all others of the same kind"

So you can't have 24 favorite Friday shirts. But in...

Looking at the responses it appears everyone else said 7. That was a mean "Trick." Now a nice "Treat" would be for you to give everyone who answered today, the...

I guess (wrong) that since 7 was your favorite number and you were giving away 7 points, it had to be 7. How cruel is that?

Coming off of a couple of recent Comic Cons (excuse me San Diego for using your personal title), Salt Lake City Comic Con and Tree City Comic Con, I just...

Thanks for the question.

The need and desire tend to wane as one nears retirement.

If a company is hacked that I use for credit stealing just 10 identities and I am one of those stolen then I would be pretty sure I'm in trouble....

Thanks for the question. I rarely use DATALENGTH

I presumed the unique key meant the uniqueness of the collection of columns making up this key. When all values are null, that was a null unique key. When some...

"When I'm 64..." Well I'm here and I still don't make triple digits. Maybe before I retire.

You want to include the answer with UPDATED, but it is the DELETED and INSERTED virtual tables.

and now MERGE too...

I use PFE for my text editor. I have for many many years (decades perhaps). I don't need Notepad, Notepad ++, or whatever new super duper text editor that comes...