这个语句供你参考,我也要回家啦,愿能给你启发:
select cast(year(date_d) as varchar(4))+'-'+cast(month(date_d) as varchar(4))+
'-'+cast(day(date_d) as varchar(4)) from Test_M
select cast(year(date_d) as varchar(4))+'-'+cast(month(date_d) as varchar(4))+
'-'+cast(day(date_d) as varchar(4)) from Test_M
其实你可以象第一同胞说的,把他的语句来修改你的DTS脚本可能会解决问题.我没试过.
这几天实在太忙了.不好意思啊.
这里有老龟奴zyq_123雍亲正当大版主,还有人称辣花摧魔前青楼名妓smoke当镇小版主,肯定能满足您的需要!!!快来吧~~~~~~