July 26th, 2013, 10:53 PM
Ms SQL 2008 - Trigger - Insert Value to Another Column
I have a table with several columns. However, there is another column that needs to be updated using the values from another column on the same table.
The table name is dbo.userobject, the column where the values are store is called login, and the column that needs to be updated is email.
The result is that everytime the "login" column has a value, the second column reflect the login value including "@email.com".
Can anyone show an example for building a simple trigger?
July 27th, 2013, 03:46 AM
you would not use a trigger for this, you would use a computed column