Improve SQL code quality with dbForge SQL Complete in a wink
In this video, you will see how seamlessly you can improve SQL code and scripts using SQL Complete.
SQL Complete offers conveniently accessible refactoring tools that help you improve code quality, and make it easier to understand and refine the design of code objects and entire databases. These tools allow renaming database objects, variables, and aliases, as well as finding invalid objects.
The killer feature of SQL Complete is T-SQL Debugger, designed to troubleshoot T-SQL scripts, stored procedures, triggers, and functions. This debugger allows observing the runtime behavior of database objects and locating logic errors. It supports step-by-step execution, call stack browsing, breakpoints, and watches.
⭐️ Timesteps:
00:00 Introduction
00:01 Refactor the names of objects declared in a script
00:49 Refactor the aliases and variables
01:00 Detect invalid objects in your SQL database and export the list of them to a CSV file
02:02 Search for an object in the Object Explorer tree
01:47 Discover the full potential of SQL Complete
⭐️Thank you for watching!
👉🏽 To discover the full potential of the tool, download SQL Complete here:
https://www.devart.com/dbforge/sql/sqlcomplete/download.html
☑️ Find more useful information about SQL Code Formatting here:
https://www.devart.com/dbforge/sql/sqlcomplete/
🔔Subscribe to the Devart Youtube channel:
https://www.youtube.com/user/DevartSoftware
#SQLComplete #CodeRefactoring #SQLFormatting #SQLDebugger #Database #SQLServer #SQL #dbForge #Devart
Video Length: 01:57
Uploaded By: Devart
Published: 3/15/2022
View Count: 573