i have a problem... i'm developing automated exam for my project.. i don't have idea when creating exam and get random questions from database and display in textBox. please help...
i'm so stress! :(
Regards,
Piatoz
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Joginder BangerPosted Nov 5, 2014, 1:06 AM
select * from tablename order by newid()
.
newid() is a predefined function in sql server
Shweta LodhaPosted Nov 4, 2014, 9:10 PM
Below link will give you an idea on how to get random records from database:
http://msdn.microsoft.com/en-us/library/cc441928.aspx