Mega Code Archive

 

Categories / MSSQL / Data Type

 

CAST(expression AS data type( length ))

5> SELECT CAST(2.78128 AS integer) 6> SELECT CAST(2.78128 AS money) 7> GO -----------           2 (1 rows affected) ---------------------                2.7813 (1 rows affected)