Welcome to Sign in | Help

Re: sqlcmd - optiuni

  •  03-31-2009, 7:32 AM

    Re: sqlcmd - optiuni

    Am utilizat comanda astfel, fara echo off

    sqlcmd -Q "use test select b.id_document from dosar a  inner join v_Document b on a.id_dosar=b.id_dosar where b.tipdocument like '%' "

    si rezultatul a fost:

    C:\Documents and Settings\..>sqlcmd -Q "use test select b.id_document from dosar a  inner join v_Document b on a.id_dosar=b.id_dosar where b.tipdocument like '%' "

    Changed database context to 'test_tril'.
    id_document
    --------------------

    (0 rows affected)

    Lansata: sqlcmd -Q "use test select b.id_document from dosar a  inner join v_Document b on a.id_dosar=b.id_dosar"

    afiseaza

    Changed database context to 'test_tril'.
    id_document
    --------------------

    180

    190

    210

    ...

    (160 rows affected)

    Multumesc.

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems