Why then does SQL Books Online say

Or am I misinterpreting that?

Hey, I would have expected a Friday the 13th fun question today. But thanks, learned something.

My question remains, why did MS decide to add this useless suffix to the @from_id and @to_id columns? It just makes a joke of the "Explicitly name columns" best practice...

Change the

IF @ID = NULL

to

IF @ID IS NULL

You cannot compare a value directly to NULL.

And that's...

Junior Galvão - MVP (5/9/2016)

Please check the correct answer!!!

The official Microsoft documentation informs the operation of verifyonly is written in the table.

To learn more visit: https://msdn.microsoft.com/en-us/library/ms187408.aspx%5B/quote%5D

Uhmmm... This...

Thanks, Brandie. I found a script on this site (http://www.sqlservercentral.com/scripts/Collation/113863/) that actually takes care of converting all the character and text based columns to a different collation. Quite handy. I...

Aerosmith country? Wow, I must have fallen into hibernation, or American Idol has eventually adopted...

Hi Everyone!

Wow, it has been 6 months or so since I last was on this thread. I haven't even been lurking, just too busy to keep up. And no, I'm...

Not sure what exactly you want. From the SQL statement you posted it will always insert data for NY and KT if it does not match Fname and Sname, but...

I think the discussion went a bit off the OP's topic. Yes, he mentioned performance in his last sentence, but basically, the answer has been provided early on. Change the...