Can i predefine fields for joining tables?

• 
  Hello Schachar,
  
  Thanks for reaching out to Redgate Software regarding your SQL Prompt inquiry. I believe you may have some luck using SQL Prompt's Code Completion and Ranked Suggestion features in this case. I am going to include the link to our documentation on both topics so you can review.
  
  Ranked Suggestion:
  https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-suggestions-into-your-code#Insertingsuggestionsintoyourcode-RankedSuggestions
  
  Code Completion:
  https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/using-and-configuring-code-completion-suggestions-quick-ref
  
  Lastly, an alternative solution you may wish to consider is utilizing a snippet in your environment to save a pre-written join clause as an alias like join1 and then you can just use the snippet to auto-write the join query.
  
  https://documentation.red-gate.com/sp/sql-code-snippets
  
  Hopefully the above gives you some ammunition to determine which solution is best for you. But let me know if you have any follow up concerns.

  cperez August 30, 2024 14:49

  - 0 +

Add comment

Please sign in to leave a comment.