I have a table and while i tried to retrive data from the table using select statement, query returns some data and then generate an error message like 'An inconsistency was detected during an internal operation in database'. Then I go through my data and found some corrupted data in some column which is not readable in normal query. Then I use convert statement and retrive the data. but still now it's not possible to retrive all data. In my findings, i reveal that, in some column, some data inserted which is actually greater than the length defined in column in table structure. basically you can't insert any record containing the value greater than the length defined. Now my question is how it is possible to insert this kind of such data? And am i Able to retrive my all data from the corrupted table?
i appreciate any help in this regard.
thanks in advance