_The Guru's Guide to Transact-SQL_ by Ken Henderson is unusually readable for a programming book. Perhaps it's a bit dated now, but still a good source of info

_The Guru's Guide to Transact-SQL_ by Ken Henderson is unusually readable for a programming book. Perhaps it's a bit dated now, but still a good source of information.