|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Multiple default values for a table
Does anyone know of way that a user can have multiple default values for a table row based on another row in the table? I realize that if I create the default value using the create table command that I can only have one static value, but I would prefer a scenerio where I could have a list of values that could go in depending on other criteria. something like a column defined as a UDF type field but only for the insert, so that it is updateable.
thanks in advance!!!! |
|
#2
|
||||
|
||||
|
I'm not sure how you'd evaluate/decide which value to use with data that hasn't been written to the record yet. Wouldn't something like this be more suited to a stored procedure?
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Multiple default values for a table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|