Error converting data type varchar to bigint啥意思？

Question

如题
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类型的

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

这样写不太对吧： CONVERT (date, GETDATE(),106)
date应该是datetimeLoanApplication.ExpiredDate是日期类型的话，直接和getdate()比较就可以啊

Answer 5

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

Answer 6

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)