Error converting data type varchar to bigint啥意思？

[myhorsefsy]

如题
select LoanApplication.LoanApplicationID from LoanApplication inner join LoanApplicationStatus on LoanApplication.LoanApplicationID=LoanApplicationStatus.LoanApplicationID
inner join RegisterLoanStatus on RegisterLoanStatus.RegisterLoanStatusID=LoanApplicationStatus.LoanStatusID
where RegisterLoanStatus.Description!='Loan Approved' and
RegisterLoanStatus.Description!='Loan Terminated'
and LoanApplication.ExpiredDate>=CONVERT (date, GETDATE(),106)
select COUNT(1) from LoanApplication inner join LoanApplicationStatus on LoanApplication.LoanApplicationID=LoanApplicationStatus.LoanApplicationID
inner join RegisterLoanStatus on RegisterLoanStatus.RegisterLoanStatusID=LoanApplicationStatus.LoanStatusID
where RegisterLoanStatus.Description!='Loan Approved' and
RegisterLoanStatus.Description!='Loan Terminated'
and LoanApplication.ExpiredDate>=CONVERT (date, GETDATE(),106)
高手帮我看一下这两段sql文啥地方不对？LoanApplication.ExpiredDate是date类型的

[昵称被占用了]

检查语句中的所有字段，有没有bingint型的，问题就在这个字段

[sql_lover]

将语句复制到查询窗口执行，双击错误代码，可现实有错的行

[sych888]

2005没有data数据类型，有datetime数据类型

[beirut003]

从标题看是类型转换出错了

[昵称被占用了]

检查范围，以下字段
LoanApplication.LoanApplicationID
LoanApplicationStatus.LoanApplicationID
RegisterLoanStatus.RegisterLoanStatusID
LoanApplicationStatus.LoanStatusID
RegisterLoanStatus.Description

[beirut003]

楼主是08？

[myhorsefsy]

问题是单语句跑，没问题！放在存储过程中就出错了

[喜-喜]

这样写不太对吧： CONVERT (date, GETDATE(),106)
date应该是datetime

LoanApplication.ExpiredDate是日期类型的话，直接和getdate()比较就可以啊

[yujunlin32167]

Error converting data type varchar to bigint
翻译过来就是将bigint长整型数据类型转换为varchar数据类型出现错误...
检查一下程序中是否有这样的转换...

[永生天地]

select LoanApplication.LoanApplicationID 
from LoanApplication 
inner join LoanApplicationStatus on LoanApplication.LoanApplicationID=LoanApplicationStatus.LoanApplicationID  
inner join RegisterLoanStatus on RegisterLoanStatus.RegisterLoanStatusID=LoanApplicationStatus.LoanStatusID  
where RegisterLoanStatus.Description!='Loan Approved' 
and  
  RegisterLoanStatus.Description!='Loan Terminated'  
  and LoanApplication.ExpiredDate>=CONVERT (datetime, GETDATE(),106)


select COUNT(1) 
from LoanApplication 
inner join LoanApplicationStatus on LoanApplication.LoanApplicationID=LoanApplicationStatus.LoanApplicationID  
  inner join RegisterLoanStatus on RegisterLoanStatus.RegisterLoanStatusID=LoanApplicationStatus.LoanStatusID  
  where RegisterLoanStatus.Description!='Loan Approved' 
and  
  RegisterLoanStatus.Description!='Loan Terminated'  
  and LoanApplication.ExpiredDate>=CONVERT (datetime, GETDATE(),106)