How to use % in OSQL from batch file? 1

[bknepher]

How can I use a "... NOT LIKE '%.gif'" (for example) in a batch file calling OSQL? The % is replaced by running the batch, thinking it is a replacable parameter. Trying % on the command line and using %1 in the quoted SQL query doesn't seem to work. It looks like it will but fails. If I double up the % "... NOT LIKE '%%.gif'" it again appears to be correct as one % is dropped but the query still fails.

 

[TJRTech]

For craps and giggles did you by-chance try using TWO percent signs in a row?

TR

 

[bknepher]

I did (see original post). It echoed to cmd window looking like it should run but the results, if any, returned by osql were completely different than the same query cut and pasted into query analyzer.

 

[TJRTech]

Use -i parameter followed by an input file name instead of using -q / -Q (inline command). In this way, the text of the T-SQL is in a file and not "eaten" or mangled by batch.

TR