SQL Prompt v4 EAP

• 
  Hello,
  
  Uppercasing of keywords has not yet been implemented and so the functionality does not work now. However, rest assured this will be done for the release.
  
  I hope that helps:)
  
  Thanks,
  Tanya
  Project Manager
  Red Gate Software Ltd
  
  

  swrobel wrote:

  SQL Prompt 4 is not auto-uppercasing keywords for me like SQL Prompt 3 did. In SQL Prompt 3 I didn't have to tab it out, it just uppercased it after I finished typing the keyword.
  
  EDIT: and yes, I do have Format > Case > Reserved Keywords set to UPPERCASE

  tanya June 11, 2009 13:03

  - 0 +
• 
  Hi George,
  
  All automatically SQL Prompt inserted code respect the format settings of the user while being inserted. We do not have any settings currently to disable this functionality. However, I can log this into our bug tracking system and have it reviewed for our next version.
  
  I hope that helps.
  
  Thanks,
  Tanya
  Project Manager
  Red Gate Software Ltd
  

  George Palacean wrote:

  Is it possible to make SQL Prompt NOT format the source code of the procedure when it auto-completes the alter procedure statement ?
  I couldn't find any option for this

  tanya June 11, 2009 16:22

  - 0 +
• 
  I have a question about formatting.
  
  Can I do something like this
  
  
  if @value = 1
  or
  @value = 2
  begin
  
  
  end
  
  Where the or's and and's are moved to another line seperately or is that outside the realm of SQL Prompt?

  aseniuk June 16, 2009 15:57

  - 0 +
• 
  Hi,
  
  I also don't like the behaviour on double-clicking identifiers. Selection stops on underlines (something like SP_Help). Therefor @variable is now selected completely. This wasn't in version 3.9. For me, I prefer the default behaviour from SSMS (always select the whole identifier). Hope you can change this or make a setting.
  
  I also would wish easy functions like $Date$, $Time$, $Username$, $Computername$ in code snippets (perhaps even $Database.dbo.ScalarFunction$) and something to import my old snippets.
  
  Thank you very much for early access (great idea!) ,
  
  Michael Kriegner

  Michael.Kriegner June 17, 2009 07:33

  - 0 +
• 
  Just downloaded the early release and tried it out. Well done. The performance is noticeably snappy. I like the UI improvements too. Looking forward to the release (so I can put it on both my machines).

  Grant Fritchey June 18, 2009 14:26

  - 0 +
• 
  Hi Tanya,
  
  I don't want SQL Prompt to reformat every procedure which I'm altering.
  Even if, let's say, the code is not properly formatted, SQL Prompt will change the whole body of the procedure, thus messing up the source version control; Besides this, any change in the user preferences will make all the stored procedures to completely change their layout when altered.
  
  This can be a very useful feature, but in the current implementation it's quite useless.
  

  tanya wrote:

  Hi George,
  
  All automatically SQL Prompt inserted code respect the format settings of the user while being inserted. We do not have any settings currently to disable this functionality. However, I can log this into our bug tracking system and have it reviewed for our next version.
  
  I hope that helps.
  
  Thanks,
  Tanya
  Project Manager
  Red Gate Software Ltd
  

  George Palacean wrote:

  Is it possible to make SQL Prompt NOT format the source code of the procedure when it auto-completes the alter procedure statement ?
  I couldn't find any option for this

  George Palacean June 30, 2009 10:43

  - 0 +
• 

  begin try
    
     set @cmd = 'dbcc inputbuffer( ' + cast(@@spid as varchar) + ')'
     
     insert into dbo.GenericTable
     (
         Event
        ,Parameter
        ,Syntax		
     )
     exec 
     (
        @cmd
     )
  
  end try
  
  begin catch
  
     set @errorMessage = error_message()
     raiserror(@errorMessage, 18, 1)
  
  end catch
  

  
  Hi All,
  
  I am wondering if there is any way to format the code like this, I would really like to have returns after exec statements when there are brackets evolved.

  aseniuk July 08, 2009 16:29

  - 0 +

Add comment

Please sign in to leave a comment.