How to get the Random Questions from my DataTable using SQL Server? [Resolved]

Posted by Iluvdotnetfunda under Sql Server on 3/28/2012 | Points: 10 | Views : 4121 | Status : [Member] | Replies : 2
Hello Friends,

Please help me in this Query.

How to get random questions from my table.
Column names in my datatable are UserAutoID, UserCategoryID, UserQuestion, UserAnswerTypeSubjective ,ObjectiveAnswer1, ObjectiveAnswer2, ObjectiveAnswer3, ObjectiveAnswer4, UserCorrectObjectiveAnswer.

Now the problem is how to get random questions from table using this column names.
Anybody Please help me.

Thanks&Regards
iluvdotnetfunda




Responses

Posted by: Ksuresh on: 3/28/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi,

Please go through below link it may helps you

http://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql

http://www.petefreitag.com/item/466.cfm
Thanks


Iluvdotnetfunda, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Iluvdotnetfunda on: 3/28/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Suresh,

Thanks .

Iluvdotnetfunda, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response