Create error message for check constraint
I was wondering if there was a way to create an error message that displays when data is entered into a table in the wrong format. (Check constraint).
Software/Hardware used:
Software/Hardware used:
ASKED:
March 16, 2008 2:51 AM
UPDATED:
September 30, 2008 6:06 PM
RELATED QUESTIONS
- ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g
- Adprep /domainprep error while upgrading from Windows Server 2003 to 2008
- How to use 'Create index' statement in iSeries Navigator
- Potential over & under security issues with SQLNative Client ?
- SQL+ running time error
Answer Wiki:
When data is entered into a column of the wrong data type an error will be returned already.
For example is a column has the data type of INT and you try to put text data into the column the database will return an error message.
If you want a text field and you add a constraint to it and the new value does not meet the requirements of the constraint an error message will return an error message.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.