title: T-SQL Cast versus Convert
body: <p>What is the general guidance on when you should use <code>CAST</code> versus <code>CONVERT</code>? Is there any performance issues related to choosing one versus the other? Is one closer to ANSI-SQL?</p>