Constraint Violating Yak Guru
Posted - 09/19/2011 : 15:51:03
| Can someone, please, please help me here; I am very, very confused.
I am grabbing ssn values from an oracle database with this query:
and I am getting the correct value of 1111
When I insert that value into a a sql server table, I am getting a different value.
For instance, let's assume that the ssn that I am grabbing is 123456789, in Oracle, I get 6789 which is correct.
However, after inserting the value a sql server db as
Insert into mytable (ssn) values(ssn), the value shows as 5678.
I also tried selecting the entire ssn as
FROM MYTABLE and then try inserting into a sql server db as:
Insert into mytable (ssn) values(right(ssn,4).
I still end up with 5678.
Can anyone, please tell me what I am doing wrong?
Thanks a lot in advance