Re: How to improve performance of the report's display while updating the table?

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 14:14:11 -0500

Uri was saying that your select has an error in it, but it does not. ( He
probably was just looking quickly.) Each one of the tables is in the where
clause, but you are using an OLD style syntax which is VERY prone to the
kinds of errors that Uri mentioned... Why don't you spend some time getting
used to and using the ANSI style join syntax - you'll be better off .... IE

select * from a inner join b with (nolock) on a.id = b.id
    inner join c on b.id = c.id
    inner join d on c.id = d.id; 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"@Ariel" <anonymous@discussions.microsoft.com> wrote in message
news:8647D87B-C082-485D-8BFF-1B822C33FA8D@microsoft.com...
> Thanks Uri and Wayne.
>
> Yes, my table got join statements within.
>
> select * from table a, table b with (nolock), table c and table d
> where a.id = b.id and
>           b.id = c.id and
>           c.id = d.id;
>
> // the b table I assume is the attendance table.
>
> uri, did you mean that my result will be wrong after I use the nolock
syntax?
> Or you mean it will be wrong in terms of some of the data it linked will
be deleted or updated?
>
> Thanks Again
>

Relevant Pages

  • Re: urlencode vs rawurlencode
    ... | This method was used to make query URIs easier to pass in systems ... in the query component of an HTTP URL. ... A URI may contain ... Syntax and Escaping", ...
    (comp.lang.php)
  • Re: Web authentication
    ... RFC 2396: Uniform Resource Identifiers (URI): Generic Syntax ... Server-based Naming Authority ... specified server on the Internet use a common syntax for the server ...
    (comp.lang.python)
  • Re: How to set Http Request Header?
    ... However 2396 is the standard for URI ... and it doesn't take precedence over specific RFCs. ... that's the syntax for /general/ URI. ... own syntax for http_URL that /does not/ follow the general pattern in 2396. ...
    (comp.lang.java.programmer)
  • Re: Time range matching
    ... IF you are trying to get all emps born during certain hourly ranges without ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > Dear Uri, ... > Declare @A varchar ...
    (microsoft.public.sqlserver.server)
  • Re: ALTER TABLE table ADD column_name
    ... Uri can probably confirm this, but I've always understood that if you change ... a table with Enterprise Manager, what it actually does is to copy the data ... name as the old one, but with the changed properties, then copy all the data ... I´m trying to add a new column in SQL Server 2000, ...
    (microsoft.public.sqlserver.server)