EmpPostRecord.vcLevelName,
EmpPostRecord.vcAdminLevelName,
EmpPostRecord.vcTechLevelName,
CONVERT(char(10), tbCLaborRelation.dBeginTime, 120) AS dBeginTime,
CASE tbContract.iTermType
WHEN '3' THEN '无固定期'
WHEN '4' THEN '完成一定工作'
ELSE CONVERT(char(10), tbCLaborRelation.dEndTime, 120)
END AS dEndTime,
tbOrganDirectory.vcFullName AS vcContractOrganName,
tbContract.iCo
这段语句有哪些可优化之处啊?
EmpPostRecord.vcAdminLevelName,
EmpPostRecord.vcTechLevelName,
CONVERT(char(10), tbCLaborRelation.dBeginTime, 120) AS dBeginTime,
CASE tbContract.iTermType
WHEN '3' THEN '无固定期'
WHEN '4' THEN '完成一定工作'
ELSE CONVERT(char(10), tbCLaborRelation.dEndTime, 120)
END AS dEndTime,
tbOrganDirectory.vcFullName AS vcContractOrganName,
tbContract.iCo
这段语句有哪些可优化之处啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货