Click here to Skip to main content
15,903,030 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
how to store college session like 2011-12 into database asp.net c# code and database
formate like integer
Posted
Comments
Prerak Patel 25-Jul-11 4:06am    
Elaborate more.
Uday P.Singh 25-Jul-11 4:08am    
what are you trying to do?

1 solution

Question is not clear, please rephrase it. However, if you are asking about storing college year as integer, I do not see a problem here you can create a database like this:

SQL
CREATE TABLE CollegeYear (
    YearNo int 
)

INSERT INTO CollegeYear (YearNo) VALUES (2010)
INSERT INTO CollegeYear (YearNo) VALUES (2011)
INSERT INTO CollegeYear (YearNo) VALUES (2012)


I used the word YearNo for the column since Year is a keyword in SQL Server.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900