时间:2021-07-01 10:21:17 帮助过:8人阅读
select cast(a.Vchcode as int) as avchcode,a.ptypeid,a.assqty,unit,b.pfullname,b.standard,b.type from ldtdlysale a left outer join ldtptype b on a.ptypeid = b.ptypeid
cast(a.vchcode as int)-------------就是他了
sql 取值时将字符串类型数字转化成整形
标签:rom sel join select cas highlight standard outer eid