Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Not null constraint
This is a discussion on Not null constraint within the SQL Server forums, part of the Databases category; What would you use to place a not null constraint on a column? If the column is left blank on insertion, it should display a custom error message. 1. Rule ...
|
|||||||
| SQL Server SQL Server is a Database Management System(DBMS) by Microsoft |
 |
| LinkBack | Thread Tools | Display Modes |
10-17-2007
|
|||
|
|||
|
Not null constraint
What would you use to place a not null constraint on a column? If the column is left blank on insertion, it should display a custom error message.
1. Rule 2. CHECK Contstraint 3. Triggers 4. Alter the table so that the column does not allow null 
|
| Sponsored Links |
|
10-17-2007
|
|||
|
|||
|
Re: Not null constraint
Alter the table so that the column does not allow null
and write a trigger to display custom eror message.
|
|
10-17-2007
|
|||
|
|||
|
Re: Not null constraint
Alter the table so that the column does not allow null..
|
|
|
«
sql
|
Custom Error message
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| null pointer | vasundhara.jagdale | C and C++ | 1 | 07-23-2007 01:38 AM |
| Oracle Null and Unique value | Subashini.Ramasamy | Oracle | 3 | 06-16-2007 09:13 AM |
| Built-in and plugin stages, Chaning Null to Not Null and Types of lookup | Geek_Guest | Data Warehousing | 0 | 04-06-2007 04:48 AM |
| Constraint based loading and incremental aggretation | Geek_Guest | Data Warehousing | 0 | 04-06-2007 04:46 AM |
| Check Constraint | christia | SQL | 2 | 07-30-2006 07:16 PM |
All times are GMT -4. The time now is 04:38 PM.
