Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - An identity column can have negative seed value and negative increments also

Aug 1 2011 3:52AM by Ramireddy   

Always we will start identity value from 1 and increment by 1. However, an identity column can have negative seed value and can be negatively also incremented. Suppose below table will have 4 rows with id values -100,-101,-102,-103

    declare @t table
    (
    	Id int identity(-100,-1),
    	Col1 int
    )
    insert into @t values (1),(2),(3),(4)
    select * from @t 
Read More..   [16 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Ramireddy
2 · 40% · 12972
11
 
8
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - An identity column can have negative seed value and negative increments also" rated 5 out of 5 by 11 readers
SQL Server - An identity column can have negative seed value and negative increments also , 5.0 out of 5 based on 11 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]