Category
Product Version
Topic
Subtopic
Code completion (4211223)
Applies to ApexSQL Complete Summary This article describes how to use ApexSQL Complete options to manage the auto-complete hint-list and use the auto-complete feature to speed up coding. ... Description To enable the Auto-complete feature, navigate to the ApexSQL Complete menu, and click the Enable auto-complete command: Once the feature is enabled each time the typing is started in the query window, the hint list appears, offering a hint to complete keyword, SQL fragment, or even entire SQL statement.
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.
Creating CRUD procedures (4216105)
This article describes how to set and use the Create CRUD procedures feature. ... This feature allows to automatically create Select, Insert, Update and Delete stored procedures using customizable templates.
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.
How to create a database cleanup report in SQL Server (4214365)
A SQL Server database can have stored procedures, tables, defaults, views etc. that aren’t being used anymore, and unless you determine which of your objects are truly unreferenced you will be stuck with them, or risk breaking your database if you delete a wrong object.
How to improve SQL code layout and presentation (4216093)
In this article, improving of T-SQL code layout and presentation using various features and options in ApexSQL Complete will be described. ... Additionally, the Code structure feature will be examined, how ApexSQL Complete highlights identifiers with brackets, how it manages closing characters, aliases, and column list.
How to export SQL Server data to a CSV file (4213502)
This article will explain different ways of exporting data from SQL Server to the CSV file. ... This article will cover the following methods: ... From the Object Explorer, select a database, right click and from the context menu in the Tasks sub-menu, choose the Export Data option:
Using VSPackages to create tool windows and customize command appearance in Visual Studio (4213003)
Now it’s time to extend our knowledge of VSPackages, and try to see what can be done with them. ... In this article, we are going to explain how to create toolbars and new windows, and customize command appearance in Visual Studio
How to determine table column dependencies within a SQL database (4216185)
One of the ways is to use a SYSCOMMENTS table. ... It is a table which contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure. ... The column TEXT in the syscomments table contains the actual code for all these objects, and knowing it you can write a code to check the dependencies:
How to create and use CRUD stored procedures in SQL Server (4299381)
Working with a database, at some point, usually means working with CRUD operations. ... Although not complex, CRUD operations are often used with SQL, so it is of great importance for developers to learn about how to create them efficiently and easily.
Retrieve unsaved SQL query scripts due to SQL Server Management Studio crash (4214865)
Imagine a situation of working in SSMS, and suddenly the power goes out, the system gets crashed, SSMS gets crashed or the work session was abruptly terminated for any other reason, which causes the loss of unsaved work on various SQL scripts.
How to track executed SQL Server queries (4289158)
In this article, a feature in ApexSQL Complete that keeps track of executed queries will be introduced. ... Executed queries is a feature that keeps track of all queries which have been executed in SSMS and Visual Studio, by saving them to the certain location.
How to preview SQL Server code structure and control flow (4209488)
The Code structure feature allows the user to easily view and find all important code blocks, and to review the SQL code structure of the query. ... The Code structure provides a tree-like form of the SQL code from the query, and it’s presented in its own panel in the SSMS, on the left side of the query window.
How to safely delete SQL database objects (4212863)
When trying to delete a database object, which has an object that depends on it, no problems can be caused, since it will not allow to be deleted: ... Could not drop object 'HumanResources.Employee' because it is referenced by a FOREIGN KEY constraint.
Improving productivity with SQL snippets (4216197)
SQL snippets can be a big boost to productivity when writing T-SQL. First, to use a SQL snippet in a script, there is no need to know the syntax, only the purpose of that SQL snippet (e.g. delete an object, create a table, etc.).
How to create DDL and DML SQL scripts for specific SQL database objects only (4213557)
ApexSQL Script is a SQL Server database migration tool which can create SQL scripts by converting SQL database objects and data into a single or multiple deployment SQL scripts, .NET solutions, or executable installers.
How to automate batch SQL object scripting and committing to source control (4211756)
<p> ... Many development teams have the need for a quick and easy but effective solution to committing SQL Server database objects to source control, but aren’t yet ready to move to full source control integration at check in/check out level.
How to track queries in SQL Server Management Studio and Visual Studio (4214794)
In this article, the feature that track SQL queries whether they be executed or unsaved and save them in the appropriate folders/files for later use in ApexSQL Complete will be described. ... ApexSQL Complete is a free add-in for SSMS and Visual Studio that speeds up coding and improve productivity using features such as SQL snippets, auto-replacements, auto inserting statements and more.
How to Import and Export SQL Server data to an Excel file (4211195)
In this article, a couple of ways to import and export SQL Server data to an Excel file will be explained: ... In SQL Server Management Studio (SSMS), there is a feature that provides for exporting data from one data source to another data source; in this case, data from SQL Server will be copied to an Excel file trough Export Wizard.
How to code faster with SQL Server code snippets (4213582)
It completes SQL statements automatically, fills in SQL fragments, generates outlines for the SQL script structure and speeds up coding with T-SQL code snippets. ... ApexSQL Complete supports inserting ready-made static T-SQL code snippets into SQL scripts, and the primary purpose of the Snippets feature is to make reusing as easy as possible and therefore avoid wasting time on repetitive coding and inadvertent errors.
How to create Visual Studio add-ins with VSPackages (4211309)
Along with macros and add-ins, VSPackages are a common tool for extending Visual Studio. ... The main reason why we are writing about them is that Microsoft announced that add-ins will be deprecated in future releases of Visual Studio.
How to use SQL code text auto-replacements (4213495)
In this article, the use of text auto-replacement feature in ApexSQL Complete will be described. ... ApexSQL Complete is a free SSMS and VS add-in that speeds up coding, and improves productivity using features such as: auto-completing SQL keywords and code fragments, SQL snippets, auto inserting statements, text auto-replacement, and more.
How to create and automate test data generation for a SQL Server database (4212801)
Adding of test data can be done by manually creating scripts or by using a specific tool. ... But for repeatable processes like continuous delivery (aka DLM, CI, continuous integration), automation of test data generation is an important consideration.
The art and science of creating SSMS 2012 add-ins- Part 3 - Creating Toolbars and new Windows (4211356)
In the previous two parts of our series, we worked on foundations of an SSMS 2012 add-in. ... We talked about the mechanism that is behind loading add-ins into SSMS, about the add-in file and the creation of basic Visual Studio 2012 add-in project.
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