Report

select random rows from sql server

by | 1 year ago | Views: 123 | Answers / Discussions: 3

how can i randomly select rows from microsoft sql server?

I've Same Question Too Answer the Question Get Live Help Now!

Sort By: Date | Rating

Guest12836113
4 months, 1 day(s) ago

use NEWID()

Read Recent Chats below:

Discussion between: Shawn White and Guest358575

Meeting held on: 1 year ago

Shawn White :: hi
Guest358575: hello
Shawn White :: how can i help
Guest358575: h r u
Guest358575: okay
Shawn White :: great n u
Guest358575: i am fine
Guest358575: i ma asking about sql server integration services
Shawn White :: good, what can i help you with on information technology
Guest358575: how i can use it?
Guest358575: i want to randomly select a number of rows from a table
Shawn White :: what do you need to use it for
Guest358575: sql server 2005
Shawn White :: There are lots of ways to select a random record or row from a database table.
Guest358575: how?
Guest358575: i want to use integration services?
Shawn White :: ok
Shawn White :: Select a random row with Microsoft SQL Server:
Shawn White :: SELECT TOP 1 column FROM table
Shawn White :: ORDER BY NEWID()
Guest358575: ya i know it
Guest358575: but i read that i can make it using integration services in sql server
Shawn White :: yes you can, my internet
Shawn White :: seems to be vey slow
Guest358575: donot mind
Guest358575: it is okay
Shawn White :: hang on for sec
Guest358575: okay
Guest358575: u there
Guest358575: or busy
Guest358575: ?
Shawn White :: SQL - SELECT TOP n or SELECT TOP Random n Rows From a Table using integration
Shawn White :: sorry just a very bad connection takes ages to type, on the phone with my isp at the same time
Guest358575: is integration is a keyword?
Shawn White :: no no
Guest358575: so what is it?
Guest358575: i mean integration services
Guest358575: it is a feature in sql server 2005
Guest358575: like reporting service and other
Shawn White :: sorry i'm going to log out and log in again,
Shawn White :: shutting down and restart my computer
Shawn White :: i'llbeback
Guest358575: okay
Guest358575: do u have a yahoo mail
Guest358575: bye
Guest358575: hello
Shawn White :: hi
Guest358575: hi
Guest358575: i have to go now
Shawn White :: ok
Shawn White :: SET ROWCOUNT @NumRows
Shawn White :: ok come back when you get a chance i'll be on most of the day
Guest358575: okay
Shawn White :: or i'll post the answer you can read it later
Guest358575: thanks
Guest358575: okay
Guest358575: see u later
Shawn White :: cya