مطالب مرتبط با «sql server 2012 developer edition download» در back soft | نویسنده: استخدام کار
SQL Server 2012 Join with padded zeros
Vote count: 0 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 ) asked 24 secs agoToby Let's block ads! بخوانید...
ادامه مطلب
