Hi All,
I am getting an SQL Error Inserted Value to LARGE FOR COLUMN .I know the cause for this error
Is there any specific error handling method where in i can find for which column the error occurs using an sql query,procedure or functions
Ex:I have a table named emp which contains 150 columns.When i use insert query to insert values.I get an error message INSERTED VALUE TO LARGE FOR COLUMNS.
I found out manually which column the error occurs but is there any other way to retrieve the column name using sql query.
Pls help me in this regard???
Thanks in Advance!!!!!
I am getting an SQL Error Inserted Value to LARGE FOR COLUMN .I know the cause for this error
Is there any specific error handling method where in i can find for which column the error occurs using an sql query,procedure or functions
Ex:I have a table named emp which contains 150 columns.When i use insert query to insert values.I get an error message INSERTED VALUE TO LARGE FOR COLUMNS.
I found out manually which column the error occurs but is there any other way to retrieve the column name using sql query.
Pls help me in this regard???
Thanks in Advance!!!!!
Comment