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 |
|
kiran0411
Starting Member
2 Posts |
 Posted - 2009-07-12 : 12:02:53
|
| Hi,I am desinging School ManageMent System DataBase.My requirement is I need to give only one unique ID for a one student in the school (whether hse is in 1st class or in 10th class).i.e., If one student joined in the school he has give one ID.When he goes to 2nd class he will continue to same ID.My problem is how to maintain academic year.How to store students data yearly wise.Thanks kiran |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-12 : 13:15:31
|
| You can store a datefield in your table which stores date when a particular detail was added/modified |
 |
|
|
kiran0411
Starting Member
2 Posts |
Posted - 2009-07-12 : 13:49:53
|
| Hi,I want to provide search, filter operation on Database by classwise,yearwise,namewise....I did't get you what your saying..will you pls explain clearly...Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-13 : 14:05:37
|
| just add a datefield like datemodified. then you can derive any values like year of addition, month,day,week etc from date value using date functions.you may default it to getdate() so that it automatically takes datetime value during data insertion |
|
|
|
|
|
|
How to Maintain academic year for SchoolDataBase