Things i wish SQL supported. The lazy man's list.
611118May 1 2008 — edited May 6 2008Things i wish SQL supported. This is the lazy man's list. Just to make things easier.
1) IT - refer to the first COLUMN in the SELECT clause.
- SELECT Name FROM Item WHERE IT is LIKE 'ABC%';
2) THEY - refer to each COLUMN in the SELECT list, individually.
- SELECT Name, Type FROM Item WHERE THEY ARE NOT NULL;
3) PK - refer to the PRIMARY KEY of the TABLE.
- SELECT * FROM Item WHERE PK = 12345;
Number 1 is what i'd like best.