Category
Topic
Subtopic
Beautify your SQL code using SQL formatter features (4289764)
In this article, ApexSQL Refactor SQL formatter features will be presented which can be very helpful in creating a well-formatted, clean SQL code. ... ApexSQL Refactor is a free SQL formatter and refactoring add-in which can be integrated into SQL Server Management Studio (SSMS) and Visual Studio.
How to format SQL code in SQL Server Management Studio (4293945)
This article will describe how to format SQL code using SQL Server Management Studio (SSMS) native options and how to format SQL code using a third-party SQL formatter tool. ... A well-formatted SQL code is easily readable and reviewing such code can be much easier and faster than a non-formatted SQL code.
ApexSQL Licensing Permissions Requirements (4373139)
When trying to open ApexSQL 2022 version products, an "Internet connection is required to continue" message comes up. ... ApexSQL 2022 version tool does an internet connection verification process by pinging id.quest.com <br>And needs to reach <span style="font-size: 11.0pt;"><span style="font-family: "Calibri",sans-serif;"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flicensing.ism.quest.com%2F&data=05%7C01%7CNodier.Garcia%40quest.com%7Cebe23feb25c24b96aa7708dbb45616ad%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638302054068664027%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=07YCu2O3DF5omdsa8njCOb9hDj%2Flsdo02nXJzjwJvp8%3D&reserved=0"
Two ways to rename SQL Server database objects (4289183)
From time to time, a database object may need to be renamed for various reasons. ... When that happens, native features for renaming SQL Server database objects can be very useful. ... But, there are big differences between just renaming SQL Server database objects in the SQL Server Management Studio and Safe renaming them with ApexSQL Refactor.
How to activate ApexSQL software manually (4216052)
To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list
The Safe rename refactor ignores table columns in JOIN clauses and generates incorrect refactoring script (4213631)
Summary ... This article explains the issue when renaming a table column used in the JOIN clause and executing the created refactoring script. ... Symptoms ... A table column is referenced in the JOIN clause of another object (stored procedure, view, user-defined function):
System.IO. FileNotFoundException: Could not load file or assembly 'Microsoft. VisualStudio. CommandBars' (4213615)
Resolution ... Check whether the Microsoft.VisualStudio.CommandBars.dll library exists in one of the following locations ... x:/Program Files/Microsoft Visual Studio/Common/7IDEPublicAssemblies/ x:/ProgramFiles/CommonFiles/MicrosoftShared/MSEnvPublicAssemblies/
Tips and tricks for using ApexSQL Refactor SQL formatting options – General options, Capitalization and Comments (4216140)
This article provides a description and an explanation of ApexSQL Refactor T-SQL code formatting options in the Formatting, the Capitalization, and the Comments tab. ... Using ApexSQL Refactor, SQL scripts, code in the query window, or a code selection from the query window can be formatted.
Rules of SQL formatting – Nesting and indenting SQL statements (4216250)
This article explains nesting and indenting of SQL statements as another aspect of SQL formatting style. ... Description ... For nesting and indenting SQL statements which are another aspect of SQL formatting style, ApexSQL Refactor can be used, a free SQL formatter with nearly 200 formatting options.
Tips and tricks for using ApexSQL Refactor SQL formatting options – Parameters, Columns, Joins, and Flow control (4214839)
This article provides a description and an explanation of ApexSQL Refactor T-SQL code formatting options under the Parameters, the Statements, the Joins, and the Flow control tabs. ... The Parameters sub-tab which is located under the Lists tab provides options for formatting objects definitions, parameters, and alignment in Data Definition Language (DDL) statements:
Online SQL formatter overview (4211386)
This article describes how SQL code can instantly be beautified using customizable options. ... The ApexSQL Online SQL formatter is a free formatting tool with over 200 formatting options. ... With the ApexSQL Online SQL formatter, SQL scripts and SQL code can be formatted in the query editor.
The "Formatting profiles with duplicate names exist" message is shown when adding a new profile or when saving changes to an existing one (4214918)
Symptoms ... This article explains how to resolve the problem with duplicate of profiles which prevents us from saving a newly created profile. ... Problem ... After creating a new profile and setting some options, when click on the Save button of the Options dialog, the "Formatting profiles with duplicate names exist" message appears:
How to set options for the Split table refactoring method on SQL Server (4215954)
This article explains how to set the options in the Split table refactoring method on SQL Server, using ApexSQL Refactor, to gain the best performance based on needs. ... When splitting a SQL Server table, the primary, and the secondary table need to have at least one column in common.
How to refactor SQL databases with ApexSQL Refactor (4210905)
ApexSQL Refactor offers the Safe rename feature for renaming SQL database objects, columns, and procedure and function parameters. ... There are three ways to open the Safe rename window: ... The Safe rename window also offers users an option to change the object’s schema:
How to improve query performance and avoid syntax errors by expanding wildcards in SQL statements (4213527)
Summary This article describes the benefits of using ApexSQL Refactor options for Wildcard expansion and follow SQL Server query design best practices. ... There are several reasons to list table columns in a SELECT statement in production code over using the SELECT * (aka “wildcard”) syntax:
Formatting option mockups and examples (4216111)
This article describes the ways in which you can format SQL code using ApexSQL Refactor features and options. ... ApexSQL Refactor is a free add-in with over 200 formatting options and nearly 15 code refactors.
ApexSQL Refactor - Overview (4213523)
ApexSQL is a Microsoft Gold Certified Partner and provides services for over 10,000 customers in over 120 countries worldwide ... ApexSQL Refactor is a SQL Server Management Studio and Visual Studio free add-in, for format and refactor SQL code and objects.
How to encapsulate code as a new stored procedure, a function, or a view (4214826)
Encapsulating T-SQL code as a database object makes that code easier to reuse. ... The Encapsulate code as feature offers creating a new stored procedure, a view, a scalar inline function, or a table inline function from any valid T-SQL code block.
Avoid implicit name resolution of objects in queries by qualifying object names (4211234)
Summary This article describes the benefits of using the ApexSQL Refactor option for qualifying object names. ... Description ... SQL Server allows multiple objects with the same name under separate schemas.
How to customize SQL formatting profiles (4216115)
Summary ... This article describes how to use ApexSQL Refactor formatting profiles and is a guidance through the process of managing profiles. ... Description ... ApexSQL Refactor has four built–in formatting profiles - ApexSQL, Compact, Extended and MSDN SQL BOL.
How to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio (4296678)
In this article we will explain how to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio. ... Installation of ApexSQL add-ins can be done in two ways:
How to remove add-ins just from Visual Studio while retaining them in SQL Server Management Studio (4296672)
This article describes how to uninstall (manually remove) one or more ApexSQL add-ins from Visual Studio, without affecting the functionality in SQL Server Management Studio. ... In this article, the example covers removing ApexSQL Complete, but the manual remove process works the same way for all ApexSQL add-ins that support integration into Visual Studio.
How to manually uninstall ApexSQL add-ins (4214937)
This article will show how to manually uninstall an ApexSQL add-in. ... This uninstall method is used when automatic uninstall process fails to remove an ApexSQL add-in from the machine. ... This article will show how to manually uninstall an ApexSQL add-in.
How to install ApexSQL add-ins and integrate into host environments e.g. SSMS, Visual Studio (4305002)
This article will show how to perform the installation of ApexSQL free add-ins and how to integrate them into Microsoft SQL Server Management Studio. ... As an example, the ApexSQL Refactor installation will be described, but the process is the same for the other two add-ins.
Minimal SQL Server permissions for ApexSQL Developer tools (4216304)
Description ... In order to properly use ApexSQL Developer tools certain minimal SQL Server permissions need to be allowed on databases that are being used. ... Required permissions ... Required permissions are public SQL Server role and the public role membership that need to be configured along with the login.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All