 <p>You can try following</p> <pre><code>use tempdb create table #ttt ( c1 int identity not null, c2 int not null, c3 int default -1, c4 as (case when c3 &lt; 0 then c3+1 else c3 end), c5 as (case when c3 &lt; 0 then 'DEFAULT VALUE' else 'USER SUPPLIED' end) ) insert into #ttt values (10, 20) insert into #ttt values (11, 21) insert into #ttt (c2) values (20) select * from #ttt /*For selections, you can use */ Select C1, C2, C4 from #ttt </code></pre>