dbForge SQL Complete 5.8.173
Released: Jan 31, 2018
5.8.173 버젼 업데이트
기능
- Code Completion Features
- ALTER MESSAGE TYPE
- DROP MESSAGE TYPE
- Suggestion in SQLCMD Mode extended
- Display a list of CHECK and DEFAULT constraints
- Unwrap sp_executesql
- OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
- XML methods suggestion XQuery
- CREATE TYPE .. AS TABLE
- CREATE TYPE .. FROM
- SET DATEFORMAT
- SEND ON CONVERSATION
- CREATE QUEUE
- CREATE AGGREGATE
- CREATE ASSEMBLY FROM
- DBCC CLONEDATABASE
- Jump between BEGIN/END - Navigate through the whole block while matching BEGIN/END statements.
- Jump between COLUMNS and VALUES in INSERT statements - Helps you easily find the corresponding values of specified columns in INSERT statements. The command will highlight the matching column and value.
- Execution warnings - Shows a warning message that may cause data loss when executing UPDATE or DELETE statements without a WHERE clause, as well as TRUNCATE.
- CRUD generator - Generates a result script for SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document.
- Run scripts on multiple databases - Executes a script on several databases via the connection you choose.
- Execution notifications - When a query execution is completed, a notification that includes name of document and duration is diplayed.
- Transaction reminder - Alerts users that a transaction has not been completed.
- Find in Results Grid - Highlights all matches either by case, or whole words, or regular expressions in the results grid.
- Copy Results Grid Headers - Copy selected column names and/or types to CSV, XML, HTML, and JSON data formats.
- Grid Aggregates - Selecting two or more rows in one column automatically opens an aggregate grid that displays calculations on the SSMS status bar.
- Named Regions - Parse named and unnamed regions automatically, as well as wrap and unwrap regions.
- Find Invalid Objects - Search for objects that refer to other, nonexistent objects in the database.
- Formatting Profile Quick Select - Quickly switch between active formatting profiles.