Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-14 : 13:34:51
|
| dave writes "hi all,how can i design a table to do the following types of data validation during an update:1. check whether a certain value is within a set of values, i.e. 'Y/N'2. check whether a value is a numeric string.i.e. someone's social security number, with the dashes stripped out.3. check whether a value is within a range, i.e. birth year between 1880 and 2000.Now, how can i use the same validations for an insert, without duplicating code?Thanks,-dave" |
|
|
|
|
|
data validation for inserts and updates