| Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating:  Points: 3 |
Hi,
By default it will allow 18 precision digits. We can not
create a identify column for the char variables . by default it will be created for Auto number. i think we cannot change the column to char .
Regards
JK
|
| Author: palla 29 Aug 2008 | Member Level: Silver | Rating: Points: 4 |
hi,
we cannot create an identity on non-numeric columns.
to insert values into identity column explicitly we have to use
set identity_insert tablename on
insert values then after insertion again
set identity_insert tablename off.
it will increment with the last inserted value.
regards
palla
|
| Author: http://venkattechnicalblog.blogspot.com/ 31 Aug 2008 | Member Level: Diamond | Rating: Points: 3 |
If the identity value is int.. then obviously it can insert upto the maximum value of an integer type.
We can achieve on char data type.
Regards,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/
|
| Author: Sriram 05 Sep 2008 | Member Level: Gold | Rating: Points: 2 |
Identity Column cannot use char,varchar it will Support int only
Identity Default will allow 18 digits
SriramRamaswamy
|