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 |
|
rico1931
Starting Member
37 Posts |
 Posted - 2009-01-19 : 16:17:59
|
| Hello everyone,I was wondering if there was a way to put a default "end" value after a record has been inserted. For example when a number like 100 is inserted sql can automatically change the value to 100px....Is this even possible? Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 02:52:27
|
| whats the purpose of this requirement? one way to do this is to create a computed column based on column you insert value for, but question is why do you need this |
 |
|
|
rico1931
Starting Member
37 Posts |
Posted - 2009-01-20 : 09:25:24
|
| well I wanted to just add it on to the end in case the user forgets to input the value but I just figured out I can do this with a spry validation. Thank you for your response visakh16 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 09:35:31
|
ok..you're welcome  |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-20 : 09:48:27
|
| If this is just for formatting purpose, rather than storing default suffix in table, I would suggest to apply it on the front-end.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
End default value