Re: MySql to Sql Server Convert LIMIT

2005-01-18 Thread Adam Howitt
ginal Message- >>From: Lori [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, January 18, 2005 12:51 PM >>To: CF-Talk >>Subject: MySql to Sql Server Convert LIMIT >> >> >>Anyone have any ideas of the best way to do a LIMIT in Sql Server? I know >

Re: MySql to Sql Server Convert LIMIT

2005-01-18 Thread Lori
Like starting from 200 and going to 300. ~Lori - Original Message - From: "Eric Creese" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, January 18, 2005 1:54 PM Subject: RE: MySql to Sql Server Convert LIMIT > LIMIT like the number of records you return

RE: MySql to Sql Server Convert LIMIT

2005-01-18 Thread Eric Creese
LIMIT like the number of records you return If so SQL server has TOP [number of records]. Not sure if that is what you are looking for? -Original Message- From: Lori [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 12:51 PM To: CF-Talk Subject: MySql to Sql Server Convert

MySql to Sql Server Convert LIMIT

2005-01-18 Thread Lori
Anyone have any ideas of the best way to do a LIMIT in Sql Server? I know sql server does not have an equivalant. I have an idea of what I want to do but wanted to get other ideas too. ~Lori ~| Logware: a new and convenient we