Warn if comparing column to itself in WHERE clause
I would love a warning to prevent the classical mistake of comparing a column with itself instead of with another column in a WHERE clause.
An example is the following, where I would like a warning where one has "qlpd.interimdisbursementid = qlpd.interimdisbursementid" as it should be qlpd.interimdisbursementid = di.interimdisbursementid instead:
SELECT *
FROM dbo.datinterimdisbursement AS di
INNER JOIN dbo.qlirologPayoutServicedata qlpd
ON qlpd.interimdisbursementid = qlpd.interimdisbursementid;
1
vote