Post reply

Regarding OSQL.

  • July 27, 2008 at 5:44 pm

    #196241

    Hi all

    Is it possible to get column values from an sql table and store it in batch file variables?

    OSQL does sumthg but i am not aware about the syntax of how to implement it.

    Help me out on this....

    Thanks in advance

  • July 27, 2008 at 8:28 pm

    #848940

    I don't believe you can store this in variables with osql.

    Powershell can do something like this if you install it on your servers.

  • July 28, 2008 at 2:19 am

    #848980

    Hi Steve

    Like in a batch file(suppose test.bat) v define variables as %1,%2 etc and v pass values to them at command line like:

    c:>test 'a' 'b'

    So is there no way v can pass column values from an SQL 2000 table to these variable from command line instead of directly specifying(as in this case as 'a' , 'b')?

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply