SqlDbx
You are not logged in.
Pages: 1
When I copy from results to editor strings get enclosed in quotes.
If I copy to external programe then strings are not in quotes.
How can i copy from results to editor without strings being in quotes.
Thanks
By default when copying from Results grid to Script editor strings are enclosed in quotes and values are comma separated.
If you press Ctrl+Shift+V or use popup menu item Paste Special->Pate Grid Results Alt. then string will not be in quotes and
values will be separated by tabs
Offline
Have you ever considered ending each line with a comma when multiple rows are selected in the results pane? I don't know how others are using it but I will usually select several rows of a column and paste it into a in() statement then add the commas. I guess it would only make sense to do that when a single column with multiple rows are selected.
Offline
There's an easier way to do it. Select values from one column and then select menu item from popup menu Generate->WHERE IN ()
Offline
Pages: 1