First glance and first suggestions

• 
  Hi,
  

  - Import from Version 2

  Please see here for a reply:
  
  http://www.red-gate.com/MessageBoard/vi ... php?t=3842
  

  - Placeholders (for date for example) --> something like $DATE$
  - Execution characters (as has been stateted elsewhere too)

  Please see here for a reply:
  
  http://www.red-gate.com/MessageBoard/vi ... php?t=3835
  

  - {TAB} for formatting snippet code

  You can now insert literal tabs into your snippet code.
  

  - Automatic execution of snippets after completion keys

  Do you mean without opening the candidate list?
  

  - When I define an alias as "ab" it creates it in QA as "tab", it would be nice if the alias is exactly created as defined

  I'm afraid I can't reproduce the problem. Could you give a step by step explanation of what you are doing?
  
  Regards,
  
  Tilman

  Tilman December 12, 2006 08:48

  - 0 +
• 
  Hi
  Thought that other users might have had some of the same ideas.
  
  Regarding the last two suggestions:
  -Automatic execution of snippets: yes, I mean without opening the candidate list.
  
  -Alias mystery solved:
  1 I defined in the options window, Alias tab the following: dbo.tblArtBasis with an alias ab. When I typed something like SELECT * FROM tblArtBas... it made the alias as tab.
  No I defined the alias without dbo. only tblArtBasis and it seems to work.
  http://www.red-gate.com/MessageBoard/viewtopic.php?t=3835
  does not give an answer on the Date-Placeholder.
  
  Cheers

  fdivis December 12, 2006 09:00

  - 0 +
• 
  I agree with the last poster that having tab-completion for the snippets (the behavior in version 2) would be preferable to popping up the selection list. I'm used to just typing:

  SELECT * FROM blah b nl<TAB>
  
  expanding to:
  
  SELECT * FROM blah b with (nolock)
  

  
  Otherwise everything is looking good so far.
  
  Paul[/code]

  pleonard23 December 12, 2006 10:59

  - 0 +
• 
  Hi again,

  Automatic execution of snippets: yes, I mean without opening the candidate list.

  I've added it to the list.
  

  http://www.red-gate.com/MessageBoard/viewtopic.php?t=3835
  does not give an answer on the Date-Placeholder.

  Sorry about that. I've now added it to the list.
  
  Tilman

  Tilman December 12, 2006 11:22

  - 0 +
• 

  fdivis wrote:

  -Alias mystery solved:
  1 I defined in the options window, Alias tab the following: dbo.tblArtBasis with an alias ab. When I typed something like SELECT * FROM tblArtBas... it made the alias as tab.
  No I defined the alias without dbo. only tblArtBasis and it seems to work.

  
  You might also be interested in knowing that SQL Prompt will automatically learn the aliases you use in the current editing session and then reinsert them for you if you have the automatic alias generation switched on. So if you don't like the alias SQL Prompt gives you, just change it and it will use the new one instead from then onwards.
  
  
  Thanks,
  Bart

  Bart Read December 12, 2006 11:39

  - 0 +

Add comment

Please sign in to leave a comment.