Sort order on inserted columns

• 
  Tim,
  
  I don't see that happening with SELECT * or INSERT INTO auto completion. Both types of auto-complete list all the columns in their natural table order.
  
  I also don't see a setting to change that behavior either.
  
  Mike

  michaelfried August 18, 2009 14:14

  - 0 +
• 

  michaelfried wrote:

  Tim,
  
  I don't see that happening with SELECT * or INSERT INTO auto completion. Both types of auto-complete list all the columns in their natural table order.
  
  I also don't see a setting to change that behavior either.
  
  Mike

  
  Try it using a temp or table variable - behaviour is different in ver. 4 than 3 - column order is NOT preserved..... This is unfortunate

  TomT August 28, 2009 19:51

  - 0 +
• 
  Yes, you are correct, it does happen with Temp Tables and Table Variables.
  
  Mike

  michaelfried August 28, 2009 20:06

  - 0 +
• 
  Hopefully this will be fixed...

  TomT August 28, 2009 20:07

  - 0 +
• 
  I am not seeing the wildcard prompt on Table Variables at all
  
  Temp tables list the columns in column order

  MikeONeill September 01, 2009 03:58

  - 0 +
• 
  I'm hoping this and the other formatting issues will be fixed soon, it's quite frustrating.....

  TomT September 01, 2009 14:01

  - 0 +
• 
  Hello,
  
  I think I might have some good news here for all of you
  
  http://www.red-gate.com/MessageBoard/viewtopic.php?t=9517
  
  Regards,
  Tanya
  Project Manager
  Red Gate Software Ltd

  tanya September 02, 2009 07:35

  - 0 +
• 
  That's great - thanks for your quick response to the problems. I appreciate Redgate's committment to solid products and great customer support.

  TomT September 02, 2009 12:38

  - 0 +
• 

  I think I might have some good news here for all of you Smile
  
  http://www.red-gate.com/MessageBoard/vi ... php?t=9517

  
  Hi everyone
  
  I have the same problem with column order in temptables.
  Downloaded and installed the new version (SQL Prompt 4 Standard build 4.0.2.53).
  But it does not change a thing. It works fine with physical tables but not with temptables:
  
  CREATE TABLE #t1 (f1 INT, f2 INT, s1 VARCHAR(20), s2 VARCHAR(20), b1 BIT, b2 BIT)
  
  SELECT * (tab afterwards)
  FROM #t1
  
  There is another problem with temptable definitions that the column order changes in the suggestionswindow. That is, in the "All suggestions" tab it is different to the "column picker" tab both when checking "List in table order" or unchecking it (btw: when checking "list in table order" it does indeed a re-sorting, but NOT in table order at all).

  fdivis October 08, 2009 03:32

  - 0 +
• 
  Many thanks for your post Florian.
  
  This is a known issue and is been already logged as a bug in our internal tracking system whose id is SP-2821.
  
  I have added your comment to this issue. Our development team is working on it and will be considered in our future release.
  
  Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.

  Anu D November 09, 2009 05:22

  - 0 +

Add comment

Please sign in to leave a comment.