我想使用sql server显示数据库的教师评级 [英] i want to show the faculty rating from the database using sql server

问题描述

我的查询如下;

My query as follows;

 SELECT F.facname, 
       BA.examdate, 
       FD.bfid, 
       FD.rate 
FROM   faculty F 
       JOIN bthfac B 
         ON F.facid = B.facid 
       JOIN facfeedback FD 
         ON FD.bfid = B.bfid 
       JOIN batch BA 
         ON BA.bthid = B.bthid 	

当我执行上述查询时，显示错误如下;



转换数据类型varchar时出错to bigint。





教师表数据库结构如下;

when i execute the above query, shows error as follows;

Error converting data type varchar to bigint.


faculty table database structure as follows;

FacId         bigint
FacName   varchar
Fac_active    char(1)

bthfac表数据库结构如下;

bthfac table database structure as follows;

BFid     bigint
BthId    bigint
FacId    varchar(40)

facfeedback table数据库结构如下;

facfeedback table database structure as follows;

BFid  bigint
Rate   int

批处理表数据库结构如下;

Batch table database structure as follows;

 BthId	    bigint	
Examdate   datetime

我上面的查询有什么问题。



请帮帮我。



问候，

narasiman P.

what is the problem in my above query.

please help me.

regards,
narasiman P.

推荐答案

你问的是：

You issue is this:

FacId	 varchar(40)	

执行此操作后的结果：

as a result when you do this:

ON F.facid = B.facid 

你试图将Varchar（40）与Bigint进行比较，你不能。因此你的错误。

you are trying to compare a Varchar(40) with a Bigint which you cannot. Hence your error.

这篇关于我想使用sql server显示数据库的教师评级的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！