skip to main
|
skip to sidebar
Tech Notes
Sam Fu
Tuesday, April 21, 2009
sort table randomly
The following sample shows you on how to sort sql table randomly:
select
* from(
select
top 20 firstname, lastname
from
[user]
)
as
result order by NEWID()
sort table randomly
The following sample shows you on how to sort sql table randomly:
select
* from(
select
top 20 firstname, lastname
from
[user]
)
as
result order by NEWID()
View the entire comment thread.
blog comments powered by
Disqus
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Comments
Powered by Disqus
Blog Archive
►
2011
(1)
►
January
(1)
►
2010
(5)
►
March
(2)
►
January
(3)
▼
2009
(35)
►
December
(3)
►
November
(1)
►
September
(1)
►
August
(2)
►
July
(1)
►
June
(1)
▼
April
(14)
sort table randomly
identity_insert
Get the current page name in javascript
Javascript refresh page
Reasons to Use Proxy Server
Create a screenshot image of a web page
Clear form values
Save a CSV File in Browser
robocopy
Disable Table Constraints
Get Client IP address
Custom Validator
JavaScript Events
Print web page as PDF in VB.NET
►
March
(8)
►
February
(3)
►
January
(1)
►
2008
(115)
►
December
(2)
►
November
(6)
►
October
(4)
►
September
(4)
►
August
(7)
►
July
(14)
►
June
(3)
►
May
(19)
►
April
(15)
►
March
(15)
►
February
(13)
►
January
(13)
►
2007
(131)
►
December
(27)
►
November
(41)
►
October
(63)
Topics
ADO.NET 2.0
(1)
Ajax
(36)
ASP.NET
(75)
BizTalk
(17)
C#
(16)
Database Design
(2)
Design Patterns
(26)
IIS
(2)
Javascript
(5)
JQuery
(1)
Kentico
(1)
LINQ
(4)
Microsoft Dynamics
(2)
Miscellaneous
(8)
Sharepoint MOSS 2007
(59)
SQL Server 2005 - BI
(4)
SQL Server 2008
(1)
System Admin
(2)
Test Driven Development
(1)
Transact-SQL
(9)
VB.NET
(7)
Visual Studio
(3)
WCF
(3)
XML
(2)
User Groups
ACS
Readify
SQL CodeCamp
Sydney .NET Users Group
Sydney BizTalk User Group
Sydney Business & Technology User Group
Sydney Deep .NET User Group
Sydney SharePoint User Group