In sql server generate Id

Yes John, you are right i didn't think that way. Thanks a lot for replying!!!

0

I don't see a need to store CNIP as part of the id for the row. "CNIP" can be added to the id for display purposes in the presentation layer:

int identityValue = (retrieve field value from resultset);
string fullId = "CNIP" + identityValue;

0

Vijay Yadav15y ago

Hey John, but in sql 'Is Identity' works for integer value only not for alphabet then how it would be possible to include CNIP in that?

0

Guest User15y ago

Open SQL Server Management Studio
Find your table in Object Explorer and right-click on it, click Design
Click on the column you want to use as an id
The bottom of the window should show the column properties. Expand the "Identity Specification" property.
Change "Is Identity" to Yes
Change "Identity Seed" to the value to want to start with.
Type ctrl-S to save your changes.

0

Vijay Yadav15y ago

Hi Naresh,
As far as i have implement this type of format, i would suggest do this through coding i.e. increment the autonum field by your logic.:)

0