In SQL Server we can get records in random order from a sql query using NEWID() Function like:
SELECT Subject FROM dbo.forumThreads ORDER BY NEWID()
Subscribe to:
Post Comments (Atom)
DotNet Interview Questions and Answers, important dot net interview questions lists with faq asked in interviews and dot net experts answers. Asp DotNet Way Covers ASP.NET 2.0, ASP.NET 3.5, jQuery, AJAX, Silverlight, .NET Interview Questions, C#, VB.NET, WinForms, Windows Forms, Sql Server and Technology News
No comments:
Post a Comment