Friday October 9th

Thursday October 8th

You Should Never Use IN In SQL To JOIN With Another Table

Do you use the following syntax? SELECT * FROM TABLE WHERE CoLumn IN (SELECT CoLumn FROM TABLE) Do NOT use that it can cause big problems if you do not understand exactly how IN and NOT IN works


It's good articles like this that set DotNetKicks apart from the rest. Keep em coming!

Go read many of the comments on the article. You'll find lots of conflicting theories as to the benefits of "never use IN, it's EVIL!"

Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how
Loading DotNetKicks...
brought to you by the Kicks Network