i have a column match_id up till now i have inserted values in it,now i have to make it a computed column with formula on it.
now i am not going to insert the value for match_id column ,insted of that when i insert a row in that table then value of match_id column should be max(match_id)+1 .
a b match_id
1 2 1200
4 3 1201
8 9 1202
now when i iniser a=12 and b=56 then match_id should calculated as max(match_id)+1 i.e
1202+1=1203 ,i had already used identity column so tell me how to achive it???
View Complete Post