0
推荐
1181
阅读
SQL技巧-把float转换成VARCHAR
Q: 如何把float转换成varchar?语句:CAST(CAST(YourColumn AS NUMERIC(x,0)) AS VARCHAR(x)), where X is the number of digits you need to store.例如:[CompanyID]--FLOAT,NULL(CAST(CAST (CompanyID AS NUMERIC(3,0)) AS VARCHAR(10))