How to randomly pick exam questions from database(sql server)

• • Reply

  13 years ago

  by I.SWATI

  SWATI BARANWAL

  , India

  Joined 13 years ago

  i'm implementing an examination system. Did anyone know how to randomly pick exam questions from the database. i'm using sql server 2000 and vb.net

  Report abuse
• • Reply

  13 years ago

  by Mulish Mehdi

  Tehran, Iran

  Joined 16 years ago

  You can select a random row using following stored procedure:

  
  Declare @LastId int, @RndId int, @Lower int, @Upper int
  
  Select @LastId = Max(QuestionId) From dbo.Questions
  
  Gen_Rnd:
  SET @Lower = 1
  SET @Upper = @LastId
  SELECT @RndId = Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)
  

  
  If Exists(Select * From dbo.Questions Where (QuestionId = @RndId))
  	Select * From dbo.Questions Where (QuestionId = @RndId)
  Else
  	Goto Gen_Rnd

  Report abuse
• • Reply

  13 years ago

  by I.SWATI

  SWATI BARANWAL

  , India

  Joined 13 years ago

  ok. but using this code i hv to pass question id then only able to retrieve..but for my system when i click the start exam button , the first question should randomly pick from the database and appear(the user no need to gv the question id).....and another thing is there any possibilities to code it in vb.net itself....help meee

  Report abuse
• • Reply

  13 years ago

  by musacj

  Musa Kubheka musacj

  KwaZulu-Natal, South Africa

  Joined 14 years ago

  I'm not sure if this will assist you in your situation but I have used

  SELECT TOP 10 * FROM tblExamQuestions ORDER BY newID()

  This SELECTs 10 rows randomly from the table...

  Thanks

  Musa

  Report abuse
• • Reply

  13 years ago

  by I.SWATI

  SWATI BARANWAL

  , India

  Joined 13 years ago

  ya it;s help me alot thank you....

  Report abuse