Warn about always true WHERE clauses such as ID = ID instead of ID = @ID
It is common to create functions and stored procedures that have parameters with the same name as fields. Sometimes the @ is mistakenly skipped when creating a WHERE condition and you end up with something like ID = ID instead of ID = @ID. I would like intellisense that warns me about this type of error.
2
votes
Tim Getsch
shared this idea
-
Emory Kempf commented
Good idea. SQL prompt suggest the @ID first sometimes, and that can get you in trouble