I need to find the error causing row from the table in sql, for example:
We have invoice table, if I need to convert the Invoice date column it results an error due to special character present at Row ID 4:
Row ID INVOICE DATE AMOUNT
1 05/22/2015 25
2 05/27/2015 85
3 05/17/2015 15
4 , 28
My question is how to find the Row ID if invoice table has billion of data.
Is there any way to get the Row ID?