sql server - Add increments of 10 to a select query in SQL -


i need target values (which needs auto incremented 10, starting 0) in sql along results fetching in query.

basically needs logic like:

set @target =0 

and in display query:

display -> @target = @target +10 

thanks help.

if require permanently in table can add identity column increment 10,

alter table tablename add colname int identity(0,10) 

Comments