SQL

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))

发表了文章 • 2016-05-22 11:06 • 0 条评论