TSQL CAST
INT to VARCHAR DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function. There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in... » read more