Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-01-19 : 02:54:03
|
| Hi AllI have an existing table of students, the school now has decided to give then a General Record No.The table structure is as followsStudents++++++++++++++NameAddressTelNo.++++++++++++++I have modified the table as Students++++++++++++++GRN.NameAddressTelNo.++++++++++++++The data already exists in the table . I just want to add the GRN No. that would be incremental E.g. it should be 20060001 for the 1st record20060002 for the secondThe rest data should be as it is Plz helpThanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-19 : 03:26:49
|
| You can define it as identity with starting value 20060001MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Adding an incremental number