Friday April 29th

Thursday April 28th

Wednesday April 27th

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

2 comments

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