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 : 5420 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	Hi Suresh, Thanks . Iluvdotnetfunda, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts