This is good practice, becasue it does allow one to get all the columns for a table quickly. As for Sergejack's wish, one can solve that simply by using another trick, which is the do a quick "find and replace" within the SQL client query interface.
If you're not familiar with that, simply press "Ctrl+H" or go to the "Edit" sub menu, select "Find and Replace", and then select "Quick Replace". Once the dialog windows presents itself, simply replace all "," with "], [". For example,
After using the "Find and Replace" feature, you will have
after which point you can just add a starting bracket, "[", and ending bracke, "]", to complete your wish.
commented on Sep 15 2011 10:40AM