123 reputation
14
bio website mattsayar.com
location Colorado Springs, CO
age
visits member for 1 year, 11 months
seen Aug 14 '12 at 16:52

Junior Software Dev for a large defense contractor
I've been programming professionally since I was a senior in high school, I suck at it, and I want to do better.


Dec
21
awarded  Notable Question
Feb
5
awarded  Popular Question
Aug
3
awarded  Student
Aug
3
awarded  Scholar
Aug
3
comment Set a column's default value to the concatenation of two other columns' values?
Thanks! Wouldn't the line CREATE TRIGGER people_insert BEFORE INSERT OR UPDATE... handle the updating as well?
Aug
3
accepted Set a column's default value to the concatenation of two other columns' values?
Aug
3
comment Set a column's default value to the concatenation of two other columns' values?
I actually do need to store the value for backwards compatibility, but this is a pretty cool approach! The OCD part of me also wants there to be a check for NULL last names, but that would probably mean you have bigger data integrity issues to worry about at that point
Aug
3
awarded  Supporter
Aug
2
asked Set a column's default value to the concatenation of two other columns' values?