Hi, This is because even thoguh you converted the data type from char to int, there would be some values which wouldnt have got converted to int. This is a...

Hi Newbie,

Just adding to wt Deepak has mentioned. Disable the constraint first, then copy the row into one more table. Delete this row.

Incase your primary key field happens to be...

Hi Ian,

The error msg :

"Error message :String or binary data would be truncated" generally occurs when the source data type is not the same as the destination data type....

the code

If @Balance => 0

.... should be written as if @Balance>=0. I think you have given it as @Balance=>0. This might be one of...