I have two table with a PK ID but one table has a padding 13 digits.
Table1 PK 1234567890000
Table2 PK 123456789
What's the best approach when joining? I have the below join but get an error
The conversion of the varchar value '7324004373918' overflowed an int column. LEFT JOIN Summary C ON RIGHT('0000000000000',B.Id) = RIGHT('0000000000000',C.id )
back soft...
ما را در سایت back soft دنبال می کنید
برچسب : sql server 2012,sql server 2012 sp3,sql server 2012 management studio,sql server 2012 r2,sql server 2012 express edition,sql server 2012 versions,sql server 2012 developer edition,sql server 2012 native client,sql server 2012 sp2,sql server 2012 developer edition download, نویسنده : استخدام کار backsoft بازدید : 315 تاريخ : سه شنبه 20 مهر 1395 ساعت: 14:12