sql server new users: Passing parameters to isql/osql -- sql server new users

Passing parameters to isql/osql

Wladimir Mutel
12/27/2005 6:19:57 PM

sql server new users:

Hi,

In isql docs, I see and example :
isql /Q "EXIT(SELECT COUNT(*) FROM '%1')"
How should I interpret it ? Where are these percent-parameters
documented ? In fact, I am looking for a way to pass some parameters to
the script executed by isql, be it through environment or through
command-line. Please give appropriate help. Thank you in advance for
your replies.

Re: Passing parameters to isql/osql

Sue Hoegemeier
12/27/2005 6:21:09 PM

Take a look at the other example in isql help topic listed
under the -q argument:
SET table = sysobjects
isql /q "Select * from %table%"

The variable table will be interpreted as sysobjects.

You can find another example and explanation in the osql
topic listed under the -P argument

-Sue

On Tue, 27 Dec 2005 18:19:57 +0200, "Wladimir Mutel"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.