17/02/2010
Return Random Values From SQL
If you want to retun random values from your table in SQL Server, Use the following query:
SELECT top 4 * FROM dbo.authors
ORDER BY NEWID()
Subscribe to:
Post Comments (Atom)
Sharepoint, ASP.NET, C#, SQL, Javascript, Jquery, CSS Blog
If you want to retun random values from your table in SQL Server, Use the following query:
SELECT top 4 * FROM dbo.authors
ORDER BY NEWID()
No comments:
Post a Comment