Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to convert double type to string type in sql
How to convert double type to string type in sql

select CAST (field name as string type)

For example, now I have a student table with a grade type double to save student grades

select cast( garde as nvarchar(50)) as 'column alias' from student

When converting, pay attention to the size of the type itself, such as large fields (length). Conversion of small types may fail