http://topic.csdn.net/u/20090507/09/9c124b54-1b25-45a6-bcda-9e6a8677272d.html
接上个问题:
SELECT replace(a.prodid,'"',''),replace(a.entno,'"',''),
replace(a.prodname,'"',''),replace(a.prodnameshort,'"','')
FROM OPENROWSET( BULK 'e:\csv\cod-act-20090430234510-0001.csv',
FORMATFILE = 'e:\csv\a.Fmt',FIRSTROW=2) AS a,jgwcplxtable b
where cast(a.prodID as uniqueidentifier )=b.prodID这样连接查询时会出现将字符串转换为 uniqueidentifier 时失败的错误,类型转换后还是不行
接上个问题:
SELECT replace(a.prodid,'"',''),replace(a.entno,'"',''),
replace(a.prodname,'"',''),replace(a.prodnameshort,'"','')
FROM OPENROWSET( BULK 'e:\csv\cod-act-20090430234510-0001.csv',
FORMATFILE = 'e:\csv\a.Fmt',FIRSTROW=2) AS a,jgwcplxtable b
where cast(a.prodID as uniqueidentifier )=b.prodID这样连接查询时会出现将字符串转换为 uniqueidentifier 时失败的错误,类型转换后还是不行
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货