convert float to varchar

SELECT CONVERT (varchar), CAST (@testFloat as Decimal (38,2))SELECT STR (@testFloat, 38, 2) Importing from Excel to sql2000, there is a list of "contacts" that have become float types, and I want to convert to nvarchar type, using the following

A. A review of the syntax format of CONVERT (): convert ([length], [, Style]) second, here is a note of the meaning of style: style is the conversion style number that is provided by the SQL Server system when converting Datatime and smalldatetime

The solution for converting float to varchar into a scientific counting method in MSSQLWhen the system was initialized, because of a colleague, there was no single quotation mark in front of the numeric data, resulting in a float type after entering

SELECT CONVERT (varchar), CAST (@testFloat as Decimal (38,2)))SELECT STR (@testFloat, 38, 2)Import from Excel to sql2000, there is a column "contact" has become a float type, I want to convert to nvarchar type, with the following statementSelect

First, review the syntax format of CONVERT (): convert ([length], [, Style]) Second, here pay attention to the meaning of style: style is the conversion of datatime and smalldatetime data to a string by the SQL Server system provided by the

It mainly describes the actual operation process of SQLServer to use convert to obtain datetime date data. In actual operation, converdatabase uses convert to obtain datetime date data. The following examples include conversions of various date

ConvertExplicitly converts a data type expression to another data type. Because some requirements often use different date formats, the following can be found inFormat the date in SQL Server. SQL Server supports the data format in the Arabic style

The main description is that SQL Server uses convert to obtain datetime date data in the actual operation process, in the actual operation with the SQL Server database using convert to get datetime date data, the following instance contains a

Processing of date data format: Result of convert (varchar (16), time 1, 20): 2007-02-01 08: 02 Result of convert (varchar (10), time 1, 23): 2007-02-01 Statement and query result:Select convert (varchar (100), getdate (), 0): 05 16 2006

Use convert in SQL server2000 to get the datetime data type style (full)Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table