More about those formatting profiles and creating and editing user-defined profiles can be found on the How to customize SQL formatting profiles page. There are four built-in SQL formatting profiles that came with the installation of ApexSQL Refactor – ApexSQL, Compact, Extended, and MSDN SQL BOL. The newly created profile will be shown under the Profile drop-down box, along with ApexSQL Refactor built-in SQL formatting profiles: Once the initial information is entered for the SQL formatting profile, click the OK button. Optionally, enter who creates a SQL formatting profile and purpose of the SQL formatting profile in the Author and Description boxes: In the Create profile window, type the name of the SQL formatting profile in the Name box. Under the Options window, create a new SQL formatting profile by clicking the New button. When it comes to creating a SQL formatter standard that will be used (applied) on all SQL codes in your company, the SQL formatter features in ApexSQL Refactor add-in can be very handy.ĪpexSQL Refactor has the feature that can help in creating SQL formatting profiles in which can be implemented SQL formatter standards by using a combination over 200 formatting options. So, in a team and their company, a SQL formatter standard should be set, which all should abide by. The main problem of each project is that there are no standards of how the SQL code should be formatted and everything is a matter of personal preference. In this article, ApexSQL Refactor SQL formatter features will be presented which can be very helpful in creating a well-formatted, clean SQL code.ĪpexSQL Refactor is SQL formatter and refactoring add-in which can be integrated into SQL Server Management Studio (SSMS) and Visual Studio.Ī well-formatted SQL code can save a lot of time in reviewing, especially when it comes to transition projects between teams.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |