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)
Inversion of Control
►
2010
(5)
►
March
(2)
ASP.NET Caching
Kentico BizForm Custom Validation
►
January
(3)
WCF Basics
Cannot resolve the collation conflict between "Lat...
Find the name of the server where the site is host...
▼
2009
(35)
►
December
(3)
Filter & Sort DataTable using LINQ
While loop in sql
Get comma seperated string
►
November
(1)
JQuery Validation
►
September
(1)
DesignMode - fix body tag as literal control
►
August
(2)
Load balancing issues for ASP.NET applications
Delete files older than certain period
►
July
(1)
Handle file upload timeout
►
June
(1)
Javascript: Clear Form Elements
▼
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)
ClientID vs. UniqueID
Backup & Restore Tips
FBA: Create and enable FBA Database
FBA: Create new zone
Import csv file into SQL server
Get the post back control
Form Based Authentication
SQL server open connections exist in a database
►
February
(3)
Unable to connect to the remote server
Load unreferenced dll at runtime
Javascript page redirection
►
January
(1)
Loop through all the text box in a form
►
2008
(115)
►
December
(2)
Deleting subdirectory restarts AppDomain
HttpHandler
►
November
(6)
Loop through files in a directory
Loop through properties of a .NET Class
Running custom HttpHandler in IIS 7
LINQ Connection String - app.config vs web.config
Importing Excel - Truncates at 255 characters
MOSS Video Format
►
October
(4)
Detect DropDownList SelectedIndexChanged on Page L...
►
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