代码之家 › 专栏 › 技术社区 › RustyHamster

转换失败varchar值

varchar type-conversion casting sql

RustyHamster · 技术社区 · 8 年前

   SELECT  
    ClientID,
    ProfileID as [Profile ID],
    Title,Name as [First Name],
    Surname as [Last Name],
    Lender,
    Product,
    LoanAmount as [Loan Amount],
    DateCompleted as [Mortgage Completed Date],
    Source as [Lead Source],
    ERC as [Erc Date],
    Casetype as [Case Type],
    email,
    HouseNameNum as Street,
    Address1 as Street, 
    Address2 as Street,
    Town as City,
    (postcode1 + postcode2) as Postcode,
    CAST('http://172.16.200.119/BPSAdmin/Legacy/CommTracking.aspx?ClientId='+ ClientID AS VARCHAR(100)) as [Perspectives Comms]
FROM Datatable

我收到的错误是:

转换varchar值时转换失败

’ http://172.16.200.119/BPSAdmin/Legacy/CommTracking.aspx?ClientId= '到数据类型int

clientid是一个int,但是,我想在字段的开头添加一些字符串,以创建到客户机文件的超链接。

关于如何解决这个问题有什么建议吗干杯

2 回复 | 直到 8 年前

Ian-Fogelman 8 年前

'http://172.16.200.119/BPSAdmin/Legacy/CommTracking.aspx?ClientId=' + cast(clientid as varchar)

Ajay2707 calm 8 年前

Int varchar

SELECT  
    ClientID,
    ProfileID as [Profile ID],
    Title,Name as [First Name],
    Surname as [Last Name],
    Lender,
    Product,
    LoanAmount as [Loan Amount],
    DateCompleted as [Mortgage Completed Date],
    Source as [Lead Source],
    ERC as [Erc Date],
    Casetype as [Case Type],
    email,
    HouseNameNum as Street,
    Address1 as Street, 
    Address2 as Street,
    Town as City,
    (postcode1 + postcode2) as Postcode,
    'http://172.16.200.119/BPSAdmin/Legacy/CommTracking.aspx?ClientId='+ CAST( ClientID AS VARCHAR(100)) as [Perspectives Comms]
FROM Datatable

推荐文章

Kris Craig · 为什么Comparer不支持C#中lambda操作的64位(长)委托返回类型?

1 年前

DutChen18 · 如何在C宏中内联触发隐式指针转换?

2 年前

bnjmn 21 · Rust:非基元强制转换:`impl Fn()`as `Fn()`

2 年前

bangingmyheadontable · windows网络代码是否违反了严格的别名规则?

2 年前

0xDED · 如何将泛型类强制转换为对象的泛型类?

2 年前

ritik sharma · 为什么我无法在cpp中将int类型转换为float?关闭

2 年前

Niclas · 变量>-1如何在C中精确求值?

2 年前

Textime · 将Varchar2转换为时间

2 年前

xpt · Go,无法将类型*int32转换为类型*int64

2 年前

A_Pickle · 如果Print语句中的Double变量已经声明/初始化为Double,为什么需要将Int强制转换为Double变量?[副本]

2 年前