Capitalization

• 
  I agree. This would be really really nice when writing. I spend a large part of the time I am writing trying to format code. And most publishers have a given style. This would be excellent.

  drsql September 06, 2006 00:12

  - 0 +
• 
  Yes me to. I think I am spending more time on capitalization than wrting the scripts

  dineshasanka September 06, 2006 03:47

  - 0 +
• 
  One more vote for capitalization

  cneller September 06, 2006 09:52

  - 0 +
• 
  I like SQL Refactor alot better than SQL Pretty Printer, but one feature that SQL Pretty Printer has that this Beta of Refactor doesn't (and I hope is added!) is the ability to transform code to either UPPERCASE, LOWERCASE or PROPERCASE. I like to set my SQL reserved words to upper case, my identifiers to lower case and functions to proper case (or as it calls it InitCase).
  
  So it takes code like this:
  
  select firstname from customer where insertdate = getdate()
  
  and makes it look like this:
  
  SELECT firstname
  FROM customer
  WHERE insertdate = Getdate()

  schaitel September 07, 2006 13:35

  - 0 +
• 

  schaitel wrote:

  I like SQL Refactor alot better than SQL Pretty Printer, but one feature that SQL Pretty Printer has that this Beta of Refactor doesn't (and I hope is added!) is the ability to transform code to either UPPERCASE, LOWERCASE or PROPERCASE. I like to set my SQL reserved words to upper case, my identifiers to lower case and functions to proper case (or as it calls it InitCase).
  
  So it takes code like this:
  
  select firstname from customer where insertdate = getdate()
  
  and makes it look like this:
  
  SELECT firstname
  FROM customer
  WHERE insertdate = Getdate()

  
  Hi,
  many thanks for your comment. This seems to be quite a popular option, so we are considering adding capitalization to SQL Refactor.
  
  Regards,
  Andras

  Andras B September 08, 2006 03:22

  - 0 +
• 

  So we are considering adding capitalization to SQL Refactor.
  

  Great!

  dineshasanka September 12, 2006 12:57

  - 0 +

Add comment

Please sign in to leave a comment.