Autofill a column according to another T-SQL statement
<p>Sorry to disturb you again. lol :)</p>

<p>I am looking at the answers given on similar questions but they are still not very helpful.</p>

<p>Here's my case:</p>

<p><a href="https://i.stack.imgur.com/q2Sbm.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q2Sbm.jpg" alt="enter image description here"></a></p>

<p>I want to change the schema on my table to auto fill one column.</p>

<p>What I understand is the update function is only for values, and would not apply when new values will be entered in the future.</p>

<p>I want to be able to set the Gname according to the Grade so that I can have. so that I can have 1 for novice or new, 2 for standard, 3- intermediate and 4- Expert.</p>

<p>Can someone help please? or direct me towards the right documentation.</p>

<p>Thanks to you all</p>