Everyone will have the same order of questions this way. 

Sent from my iPhone
Stephen Russell
901.246-0159


On Mar 28, 2011, at 1:12 AM, Nitesh Katare <[email protected]> wrote:

> 
> i want to know the code for generating random questions from the
> database for different users different questions.
> 
> 
> 
> SELECT TOP 5 [ColumnName1], [ColumnName2]
> FROM [TableName] 
> ORDER BY NEWID()
> 
> The Above Query will help u to select random records.
> -- 
> N i t i :-
> The future belongs to those who believe in the beauty of their dreams...
> 
> 
> -- 
> You received this message because you are subscribed to the Google
> Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
> Web Services,.NET Remoting" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
> or visit the group website at http://megasolutions.net

-- 
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net

Reply via email to