How to auto-increment into other columns

I would strongly discourage you from doing anything like this. 

 

What is the purpose? What is the exact reason for doing this?

 

Such data can always be built with a simple select statement. So please share the rationale behind this.

 

Technically, we can do anything, but there is always a best way to achieve the end result.

declare @t table (id int)

insert into @t

select 10

union all

select 20

union all

select 30

union all

select 40

select id ,sum(id) over (order by id ) from @t

http://stackoverflow.com/questions/5669198/how-do-i-auto-increment-a-column-in-my-table

 

 

http://stackoverflow.com/questions/5931472/insert-auto-incremented-value-into-another-tables-column

 

 

 

http://stackoverflow.com/questions/15823814/multiple-identity-columns-or-a-way-to-auto-increment 

Hi Riya,

 

Create a stored procedure and perform a calculation and store the result in table while inserting the record. It will help you!.. Note( If the calculation has dynamic calculations)