将int转换为varchar [英] Cast int to varchar
本文介绍了将int转换为varchar的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下查询,需要将 id
转换为 varchar
I have below query and need to cast id
to varchar
模式
Schema
create table t9 (id int, name varchar (55));
insert into t9( id, name)values(2, 'bob');
我尝试的
select CAST(id as VARCHAR(50)) as col1 from t9;
select CONVERT(VARCHAR(50),id) as colI1 from t9;
但它们不工作。请建议。
but they don't work. Please suggest.
推荐答案
您需要 cast
或 convert
作为 CHAR
数据类型,没有 varchar
数据类型,您可以将数据转换/转换为:
You will need to cast
or convert
as a CHAR
datatype, there is no varchar
datatype that you can cast/convert data to:
select CAST(id as CHAR(50)) as col1
from t9;
select CONVERT(id, CHAR(50)) as colI1
from t9;
在 SQL Fiddle :
/*! Build Schema */
create table t9 (id INT, name VARCHAR(55));
insert into t9 (id, name) values (2, 'bob');
/*! SQL Queries */
select CAST(id as CHAR(50)) as col1 from t9;
select CONVERT(id, CHAR(50)) as colI1 from t9;
除了您试图转换为不正确的数据类型,您用于 convert
的语法不正确。 convert
函数使用以下语句,其中 expr
是您的列或值:
Besides the fact that you were trying to convert to an incorrect datatype, the syntax that you were using for convert
was incorrect. The convert
function uses the following where expr
is your column or value:
CONVERT(expr,type)
CONVERT(expr USING transcoding_name)
您的原始查询语法向后。
Your original query had the syntax backwards.
这篇关于将int转换为varchar的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文