Results 1 to 8 of 8

Thread: MSSQL 2000 ...

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    End User/Developer dNA's Avatar
    Join Date: Apr:2005
    Location:
    Posts: 564

    Question MSSQL 2000 ...

    -:

    SELECT *
    FROM Clients INNER JOIN Brokers ON Clients.A = Brokers.A
    WHERE Clients.B = 1




    SELECT *
    FROM Clients INNER JOIN Brokers ON Clients.A = Brokers.B AND Clients.B = 1


    .. - '' - where join- join .
    ", -"
    - -...

  2. #2
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    Quote Originally Posted by dNA
    SELECT *
    FROM Clients INNER JOIN Brokers ON Clients.A = Brokers.B AND Clients.B = 1
    OR -, AND
    ,

  3. #3
    End User/Developer dNA's Avatar
    Join Date: Apr:2005
    Location:
    Posts: 564
    Quote Originally Posted by Pa3KaTaH
    ... ,
    - .
    Execution Plan Query Analyzer-, ,
    Delphi where. , -, join- , ...
    ", -"
    - -...

  4. #4
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    , 1 ,
    - WHERE AND... ?
    2

    ? -

  5. #5
    End User/Developer dNA's Avatar
    Join Date: Apr:2005
    Location:
    Posts: 564
    Quote Originally Posted by Pa3KaTaH
    ... ?
    2
    - , - .
    , , Query Analyzer-

    ", -"
    - -...

  6. #6
    Automatic Jack
    Join Date: Feb:2004
    Location:
    Posts: 216
    Quote Originally Posted by dNA
    - .
    Execution Plan Query Analyzer-, ,
    Delphi where. , -, join- , ...
    ! . query analyzer-a . , query- - .

  7. #7
    Total h4x0r Sertys's Avatar
    Join Date: Aug:2001
    Location: Sofia
    Posts: 807
    . query sql92 . - . , - , query. .

    parse query- execution .

    , , , , .


    "", , "SELECT * FROM table1" , , SP- -.
    By replacing numbers with their logarithms, you just turn a multiplication problem into an addition problem.

  8. #8
    End User/Developer dNA's Avatar
    Join Date: Apr:2005
    Location:
    Posts: 564

    Thumbs down

    Quote Originally Posted by Sertys
    ... "", , "SELECT * FROM table1" , , SP- -.
    ...
    ", -"
    - -...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |