Francisco Tapia
fhtapia at gmail.com
Fri Mar 11 13:05:34 CST 2005
IIRC you can set it to 0 for all records On Fri, 11 Mar 2005 08:06:33 -0600, Robert L. Stewart <rl_stewart at highstream.net> wrote: > Steve, > > There is a property of the query where you can set the number of rows it > returns. The default is 10,000. You just need to change it to 1,000,000 > so that you will always get all of them. > > Robert > > At 07:58 AM 3/11/2005 -0600, you wrote: > >Date: Fri, 11 Mar 2005 07:51:53 -0600 > >From: Steve Erbach <erbachs at gmail.com> > >Subject: [dba-SQLServer] Update query through Access ADP > >To: dba-sqlserver at databaseadvisors.com > >Message-ID: <39cb22f3050311055164bdfd7b at mail.gmail.com> > >Content-Type: text/plain; charset=US-ASCII > > > >Dear Group, > > > >I've been looking through some of a client's ASP application with a > >view to making some slight modifications. (There are almost 800 ASP > >files. Yikes!) > > > >The back end is SQL Server and I've been using Access 2003 to > >construct views and stored procedures. I've been working on a COPY of > >the tables on my own SQL Server rather than the customer's live data. > > > >What's got me curious is this: I've been working with an sproc that > >updates a column containing an email address. It looks something like > >this: > > > >UPDATE Projects2 > >SET ContactEmail = NULL > >WHERE (Contact = '') OR (Contact = ' ') OR (Contact IS NULL) > > > >So if the Contact name doesn't have anything in it, I want the > >Contact's email address to be NULL. At present, there's a default > >e-mail address in every row. > > > >After the sproc runs I look at the table itself. Well, this table has > >133,000 records in it. Access 2003 shows me the first 10,000 by > >default. But when I go past the 10,000th record, the e-mail column > >still has addresses in it even though the Contact field is empty. > > > >Is there something I'm missing in the sproc? Something like a command > >that says, "OK, I really, REALLY want to update the rows beyond > >10,000, too." > > > >Regards, > > > >Steve Erbach > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://pcthis.blogspot.com | PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...