select StrName_lb=case when right(ms.dis_authors,1)=';' then left(ms.dis_authors,len(ms.dis_authors)-1) else ms.dis_authors end,
nGJC=ms.keywords,nEGJC=ms.ekeywords,StrTitle=ms.title,StrTitleEnglish=ms.etitle,
ZhongTuFLH=ms.book_class_number,ShouGaoRQ=convert(varchar(10),ms.receive_date,23),WenZhangBH=ms.article_number,WenXianBSM=ms.literature_code,
StrSummary=ms.Summary,StrSummaryEnglish=ms.Esummary,Doi=ms.Doi,StrSpeciality_C=sp.spec_name,ZhuanYeDM=sp.country_code, StrSpeciality_E=sp.spec_ename
from manuscript ms left join specialty sp on ms.spec_id=sp.spec_id
where manu_id=manu_in_column
and ms.mag_id=mag_id;
以上是我的语句,麻烦大家帮忙看看哪儿出错啦?谢谢。
nGJC=ms.keywords,nEGJC=ms.ekeywords,StrTitle=ms.title,StrTitleEnglish=ms.etitle,
ZhongTuFLH=ms.book_class_number,ShouGaoRQ=convert(varchar(10),ms.receive_date,23),WenZhangBH=ms.article_number,WenXianBSM=ms.literature_code,
StrSummary=ms.Summary,StrSummaryEnglish=ms.Esummary,Doi=ms.Doi,StrSpeciality_C=sp.spec_name,ZhuanYeDM=sp.country_code, StrSpeciality_E=sp.spec_ename
from manuscript ms left join specialty sp on ms.spec_id=sp.spec_id
where manu_id=manu_in_column
and ms.mag_id=mag_id;
以上是我的语句,麻烦大家帮忙看看哪儿出错啦?谢谢。
ms.keywords as nGJC
其它的自行更改
or
CONVERT(ms.receive_date,datetime)