I'm using MKS Korn shell on NT and want to execute SQL Server's isql
program with the -Q "query string" option.
ISQL requires that any embedded quotes within the double quotes surrounding
the query string be single quotes. I have a shell variable that I want to
pass to a stored procedure, but since this needs to be within single quotes
it won't get interpreted by the shell.
E.g., how would I do the equivalent of the following?
isql -S$servername -U$username -P$password -d$database -Q "exec sp_setcolor
and have the stored procedure sp_setcolor sent the parameter 'blue'?