September 20, 2002 at 9:20 am
Hi Everybody:
I have one table in my database, it has 6 columns, and 4 of 6 columns are float data type...and some columns of this 4 columns have bad data (like, their numerical value out of range), I can not build index including this 4 columns since there are some bad data in it. Now I need to find which row and what column has bad data so that I can either update data or delete the row.But I could not find the way to locate the row with bad data..when I do "select column from thetable', SQL stops execution when it first encounters the row with bad data....Can anyone please give me some suggestion on how to solve this problem? Thanks alot...
September 20, 2002 at 8:54 pm
Hi,
Did you run any DBCC command in the DB or table? If you don't, why don't you try DBCC CheckDB or DBCC CheckTable.
Tell me if they show you something
September 23, 2002 at 5:20 am
The table should have failed when the first item was attempted to be done this way. How did the data get out of range. What are you trying to do as I think maybe we are missing soemthing here?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 30, 2002 at 6:56 am
Thank you guys for your reply...
I did use DBCC to check the table...it did not change anything...
The bad data was generated by value divided by zero...By the time, we found out, it was already in the system...now we are trying to build composite index including the column that has the bad data and SQL won't let us...so we have to locate these bad data so that we can either update these data to zero,or delete the row...But it seems no way to locate these bad data...Any suggestion? Thanks alot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply