将varchar值'Netlover Broadband‘转换为数据类型int时转换失败

Question

CREATE VIEW Customer_view
as select customerID, first_name, last_name, DOB, contact_number, customer_address, Customer_email, joined_date,convert(int,c.Plan_Name) as 'mega plan'
from Customer as c, MegaPlan as m, ACCESS as a
where c.Plan_Name=m.Plan_Name and c.Plan_Name = a.AccessID

我正在尝试创建一个视图，其中显示所有客户的所有详细信息，超大计划和访问类型

我该如何解决这个问题呢？

Answer 1

我认为c.Plan_Name列的数据类型是varchar(n)，它包含一些显示错误的文本值。不要将其转换为整数。