纠正此错误--- SQL SERVER 2005 [英] Rectify this error--- SQL SERVER 2005

问题描述

select VehicleNo,CONVERT(VARCHAR(10),FDate,101) AS FDate+'-'+CONVERT(VARCHAR(10),TDate,101) AS TDate as Date,TKM,Mile,Driver1+'/'+Driver2 as Driver,Cleaner,AdvAmt,Tfrieght,TDQty,TDAmt,TEAmt,NetBal from TripSheet 

此查询是否包含任何错误...

我想将发件人和截止日期显示为 2012年6月25日

Is this query contains any mistakes......

I want to display From And To Date as 25/06/2012-30/06/2012

推荐答案

您将合并到列，因此无需与所有列别名一起使用
用作

You are merge to columns so you do not need to use as with all columns alias
use as

(CONVERT(VARCHAR(10),FDate,101)+'-'+CONVERT(VARCHAR(10),TDate,101)) as [DATE]

不是这个

not this

CONVERT(VARCHAR(10),FDate,101) AS FDate+'-'+CONVERT(VARCHAR(10),TDate,101) AS TDate

select convert(VARCHAR(30),CONVERT(VARCHAR(10),FDate,103) +'-'+ CONVERT(VARCHAR(10),TDate,103)) as Date

使用它会给您想要的结果.

use this it will give you desired result.

这篇关于纠正此错误--- SQL SERVER 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！