A C# / SQL Query Problem

[Cem Louis]

Hi,

I want to send to SQL server a query I want to get randomly generated
100 rows where they are no generated before. I made my query like
below:

mySqlCommand.Co mmandText = "SELECT name,rand(name) FROM people LIMIT
100 WHERE generated_befor e IS NULL";

Gives system error???

Thank you,
Cem Louis

[Rico Wind]

Re: A C# / SQL Query Problem

cemlouis@phreak er.net (Cem Louis) writes:
[color=blue]
> Hi,
>
> I want to send to SQL server a query I want to get randomly generated
> 100 rows where they are no generated before. I made my query like
> below:
>
> mySqlCommand.Co mmandText = "SELECT name,rand(name) FROM people LIMIT
> 100 WHERE generated_befor e IS NULL";[/color]
Use
"SELECT name FROM people ORDER BY NEWID() LIMIT 100"

/rw

[Rico Wind]

Re: A C# / SQL Query Problem

Rico Wind <rw@blade22.cs. aau.dk> writes:
[color=blue]
> cemlouis@phreak er.net (Cem Louis) writes:
>[color=green]
> > Hi,
> >
> > I want to send to SQL server a query I want to get randomly generated
> > 100 rows where they are no generated before. I made my query like
> > below:
> >
> > mySqlCommand.Co mmandText = "SELECT name,rand(name) FROM people LIMIT
> > 100 WHERE generated_befor e IS NULL";[/color]
> Use
> "SELECT name FROM people ORDER BY NEWID() LIMIT 100"[/color]
Sorry, not sure the above works, this should however work just fine
"SELECT TOP 100 name FROM people ORDER BY NEWID()"

/rw

[Cem Louis]

Re: A C# / SQL Query Problem

Thank you Rico,

It is working right...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!