22,206
社区成员
发帖
与我相关
我的任务
分享
select * from hetongrzrq where isdate(hetongrzrq)=0
UPDATE s
SET s.HTBegin = CONVERT(DATETIME, b.hetongrzrq, 25)
FROM houtaishuju s
,hetongbianhao b
WHERE s.DWID = b.DWID
AND s.MENID = b.MENID
AND s.MENBH = b.MENBH