Cheating at TSQL

TSQL code snippet cheat sheet.

List of columns in table:

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