From this link : CAST is an ANSI standard while CONVERT is a specific function in the SQL server. There are also differences when it comes ... ... <看更多>

Both CAST and CONVERT are functions used to convert one data type to another data type. The Microsoft SQL ... ... <看更多>

CLR user-defined types can be used with CAST and CONVERT as shown in the documentation. From example 'I' there: CREATE ASSEMBLY mytest FROM ... ... <看更多>