Cheating at TSQL

TSQL code snippet cheat sheet.

List of columns in table:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME=N'useraccount'