Last post Aug 20, 2010 02:19 AM by AmruthaRaghavan
Aug 17, 2010 01:50 AM|AmruthaRaghavan|LINK
I am thinking about creating an online exam application using asp.net + C # and Server. To do this need some suggestion and help from experts.
My requirements are:-
Aug 17, 2010 04:10 AM|Yawer Iqbal|LINK
You can select random records from table in TSQL using newId function, please check this
Regarding 2nd issue you can have a temporary table and copy question numbers (selected randomly) with reference of exam and candidate id.
Hope it is helpful.
Aug 17, 2010 04:32 AM|AmruthaRaghavan|LINK
Thanks Iqbal ,
NEWID(); will be OK for my requirement.
But I have a little doubt on using temporary tables.Will temporary table get distroyed when the connection to the database closes. In that situation is it good to use temporary tables.
Aug 17, 2010 06:04 AM|Yawer Iqbal|LINK
I did not mean in memory logical tabels rather I meant was a database table may be with name selected questions/ examQuestions. It can have 2 foreigon keys (in my opinion) candidate id (id of user who is appearing in exam) and exam id (in case you have multpl
exams). It can have multiple column or just one colmn named question id. When your stored procedure will return randomly selected questions same results will be saved in this table.
Hope it is helpful
Aug 20, 2010 02:19 AM|AmruthaRaghavan|LINK
Thank you Yawer Iqbal...
I think that will be fine.