I need to insert data to table #t with incremental by 1
so max id for records on #t is 3 so
if i insert multi rows as 4 rows to table #t then it must take 4,5,6,7
but this not happen all records take 4
so how to solve this issue please
i don't need use identity column so how to increment every row by 1 without using identity column
so how to do that please
expected result
id name
1 ahmed
2 ali
3 ala
4 islam
5 sayed
6 wahdan
7 warshan