Just a collection of useful functions, clauses, techniques.
SELECT suser_sname() --Get login used on this connection
SELECT DATALENGTH(Data) from tbl_IMG_Jpg --Get the number of bytes in an Image column
SELECT CONVERT(DateTime, CONVERT(varchar(10), GetDate(), 120), 120) --Strip the time from a DateTime/Get date part
--Example correlated subquery with aliases
See BIL1323
