SQL Format as CLR function

• 
  Thank you for your post, Are you able to clarify your feature request? Are you referring to the custom formatting styles in SQL Prompt?

  Ben_P January 31, 2024 18:22

  - 0 +
• 
  When in a query window, we can right click and choose Format SQL.
  There is a bulk method shown here: https://www.red-gate.com/hub/product-learning/sql-prompt/bulk-formatting-of-the-sql-server-sql-files. "i would prefer if i could stay in code"
  
  So what I would like to have is a CLR function where I could do the same, like:
  SELECT [master].[redgate].format_sql(@expression, @style, ... )

  PawJ February 12, 2024 12:34

  - 0 +
• 
  Hi @PawJ,
  
  The bulk formatting commands and bulk code analysis are available in the SQL Prompt menu as seen here:
  
  https://documentation.red-gate.com/sp/features-available-only-in-sql-toolbelt-essentials-and-sql-toolbelt/bulk-operations/bulk-operations-in-ssms/bulk-formatting  
  

  Ben_P February 26, 2024 13:08

  - 0 +
• 
  Hi Ben
  
  But it wasn't what I asked for!
  
  
  I requested a CLR function to prepare scripts using a function.
  However, you are asking me for the following:
  
  

  1. Export my code to a file
  2. Starting the application up and bulk format the folder
  3. Importing the formatted code file
  4. Saving the script..

  
  

  This appears to be quite thorough.
  
  But it's fine if you don't see the use case and decide not to implement this functionality...
  
  

  PawJ February 28, 2024 13:29

  - 0 +
• 
  Hi @PawJ
  
  Sorry, I misunderstood the request. This isn't something that the team are currently looking into, but if this is a feature that you'd like to see in the future, then you can post your suggestion to our UserVoice forum below:
  
  https://redgate.uservoice.com/forums/94413-sql-prompt
  

  Ben_P March 08, 2024 11:25

  - 0 +

Add comment

Please sign in to leave a comment.