- Code: Select all
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isql.exe" -Q"%sel%" -U username -P password -S servername -d dbname -w 1000
I have a text file that contains a bunch of queries (each on a separate line, some are pretty long) that I need to run periodically. What I used to be able to do is simply shift+arrow down (with cursor in the home position) to select the line and then ctrl+shift+1 to execute the tool. This would work great and allowed me to step through my text file of queries one at a time, rather quickly.
Since about v10 or v11 of UE, something has changed (and it might not be UE necessarily). The tool still works, but my method of selecting lines seems to add a CR to the %sel% now, and the execution of the tool now fails.
I can select the line using shift+end and the tool works correctly. However, since some of the queries that I have can be quite long, it results in lots of horizontal scrolling in UE. It is really just a nag, but it does sometimes cause me to lose my place in the text file.
Just wondering what has changed or if there is a setting somewhere that I am missing.