|
现有字段QDRQ：2014-03-21
想把该字段值赋予一个给另一个字段QDRQY，显示格式为：Mar.21.2014
set language 'english'
update B set B.QDRQY=a.qdrqa
from B,(select qdrqa=stuff(stuff(convert(varchar(11),qdrq,109),4,1,N'.'),7,1,N',') from B) a
哪里需要这么复杂 create proc z_XSHT_ENGLISH @djlsh int as set language 'english' UPDATE b set QDSJY=CONVERT(VARCHAR(11),QDSJY,109), ... FROM XSHTH AS b WHERE b.DjLsh=@djlsh
|
