SQLTeam.com | Weblogs | Forums

Computed Column remains NULL after INSERT


#1

This may be real basic but for the life of me can't figure this out.

I have a few computed columns in my table (SQL Server 2016). Combing a first and last name for example. When I do an INSERT those computed columns remain null. How can I get the computed columns to update themselves?

Thanks in advance.


#2

And about 30 seconds after I post this I figured it out ...sigh.

I updated one of the columns related to the computed column and that does the trick.