Results 1 to 9 of 9

Thread: MSSQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location:
    Posts: 1,058

    MSSQL

    , MSSQL SQL , . , .

    :

    Code:
    SELECT *, data AS Expr1
    FROM PROVERKA
    WHERE (data = 'Jun  9 2006')
    , , ( , ).
    Excel, ? *, , .
    ... , ,
    , ... ?

  2. #2
    Master of Magic Ar4i's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 6,563
    SELECT *, data AS Expr1
    FROM PROVERKA
    WHERE data between '2006-01-01' and '2007-01-01'

    , .
    Ar4i

  3. #3
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location:
    Posts: 1,058
    Quote Originally Posted by Ar4i View Post
    SELECT *, data AS Expr1
    FROM PROVERKA
    WHERE data between '2006-01-01' and '2007-01-01'
    , !

    @bsb , (< >) . :

    Code:
    SELECT *, data AS Expr1
    FROM PROVERKA
    WHERE data > 'Oct  1 2006'
    , , .. , Ar4i, .
    ... , ,
    , ... ?

  4. #4
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location:
    Posts: 1,058
    . :

    Code:
    SELECT *, Table1.[] AS Expr1
    FROM Table1, Table2
    WHERE Table1.[] <> Table2.[] AND 
        Table1.[] = Table2.[]
    , Table2 , .
    , , 1 -1 , 1 1 -2 . , .

    .: , (<>) .
    ... , ,
    , ... ?

  5. #5
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    SQL MS SQL ,
    SELECT * FROM <table> WHERE time > '13:00:00' ( ).
    , WHERE data > '06-09-2006' - .

  6. #6
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    , , ?

  7. #7
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location:
    Posts: 1,058
    Quote Originally Posted by bsb View Post
    , , ?

    , !

    Code:
    SELECT *, Table1.[] AS Expr1
    FROM Table1, Table2
    WHERE Table1.[] <> - Table2.[] AND 
        Table1.[] = Table2.[]
    @Tarvin , !
    ... , ,
    , ... ?

  8. #8
    Mire-x
    Join Date: Apr:2005
    Location: Sofia
    Posts: 763
    select *, table1.[] as expr1
    from table1, table2
    where abs(table1.[]) <> abs(table2.[])
    and abs(table1.[]) = abs(table1.[])

    abs(expr) ... ? , abs(-1) abs(1) 1.
    (10b) || !(10b)

  9. #9
    Mire-x
    Join Date: Apr:2005
    Location: Sofia
    Posts: 763
    , , , . -, abs().
    (10b) || !(10b)

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 |