How to create a column that can never be updated?

Posted by Randy Minder on Stack Overflow See other posts from Stack Overflow or by Randy Minder
Published on 2010-05-22T19:01:10Z Indexed on 2010/05/22 19:10 UTC
Read the original article Hit count: 357

Filed under:

In SQL Server 2008, is it possible to create a column that can have a value inserted into it, but can never be updated? In other words, the column can have an initial value inserted into it, but once it contains a non-null value, it can never be changed. If possible, I would prefer to do it without using a trigger.

Thanks - Randy

© Stack Overflow or respective owner

Related posts about sql-server