Previous Next

T-SQL Context Prompt - Code More Efficiently!

dbForge SQL Complete and its embedded T-SQL prompts give you a chance to implement code routines rationally. T-SQL context prompt accelerates the SQL code writing by offering a list of database objects and T-SQL statements to be inserted based on the context of what you type in the SQL editor.

SELECT suggestion

Use the column picker for simple selection of required columns.

SELECT Suggestion

FROM suggestion

The FROM block contains tables, views, table functions, XML vars, table vars, and datetime vars.

FROM Suggestion

GROUP BY suggestion

Use the column picker in blocks with multiple choice.

GROUP BY Suggestion

HAVING suggestion

The columns suggestion is available in the HAVING block, while setting function parameters.

HAVING suggestion

ORDER BY suggestion

If you declared columns and aliases in the SELECT statement, the suggestion list will show them in the ORDER BY statement.

ORDER BY suggestion

TOP suggestion

Suggestion of functions and variables is available in the TOP statement.

TOP suggestion

OFFSET suggestion

In the OFFSET statement, depending on its context, the suggestion of keywords, variables, or objects is available.

OFFSET suggestion

SELECT INTO suggestion

While creating a table with the help of SELECT INTO statement, the database schema suggestion is available.

SELECT INTO Prompt

FOR XML suggestion

Keywords suggestion for the FOR XML clause is available.

FOR XML suggestion

Window and ranking functions suggestion

Columns and objects suggestion for window and ranking functions is available.

Window and ranking functions suggestion

COLLATE suggestion

For all string data the COLLATE suggestion is available.

COLLATE suggestion

Automatic generation of the JOIN clause

You can use the automatically created JOIN statement while combining tables. You can also select table objects from a required schema manually, in case you need a specific join operation.

Automatic generation of the JOIN clause

JOIN suggestions

You can select the pre-set JOIN statement for tables that are joined with a foreign key.

JOIN suggestions

INSERT suggestions

Use the сolumn picker to select required columns to be included into the INSERT statement.

INSERT suggestions

INSERT VALUES suggestion

Variable and scalar functions are suggested in the VALUES block for the INSERT statement.

INSERT VALUES suggestion

OUTPUT suggestion

There is the possibility to display required data using INSERTED, in the OUTPUT statement.

OUTPUT suggestion

Suggestion for virtual tables

Column suggestion list is available for the INSERTED statement.

Suggestion for virtual tables

INTO suggestion

There is the possibility to insert execution results into the available table object.

INTO suggestion

Suggestion for XML in FROM clause

XML vars suggestion is available in the FROM statement.

Suggestion for XML in FROM clause

Built-in method suggestion for XML datatypes

Suggestion for built-in methods is available for XML-type variables.

Built-in method suggestion for XML datatypes

XML alias suggestion

Suggestion for built-in methods is available for XML-type variables via aliases.

XML alias suggestion

XML built-ins suggestion in SELECT

The SELECT statement displays custom variables and built-in methods to work with these variables.

XML built-ins suggestion in SELECT

XML built-ins suggestion in SET

While modifying XML data, an appropriate method is suggested.

XML built-ins suggestion in SET

XML column suggestion

Suggestion of built-in methods for XML columns.

XML column suggestion

PIVOT suggestion

Columns and aliases suggestion is available for the PIVOT statement.

PIVOT suggestion

SET IDENTITY_INSERT suggestion

In the SET statement the suggestion list shows objects, if it is allowed by syntax.

SET IDENTITY_INSERT suggestion

Variables suggestion for SET commands

For the SET statement that expects a value, the suggestion list shows appropriate variables.

Variables suggestion for SET commands

SET command suggestion

Extended suggestion for all the SET options is available.

SET command suggestion

UPDATE suggestion

Custom tables and views are suggested in the UPDATE statement.

UPDATE suggestion

UPDATE SET suggestion

The suggestion list shows all the available columns for the selected object. You can refer to these columns via the name of the object that is being updated.

UPDATE SET suggestion

Updating value suggestion

For the column, that is being updated you can set a value using either a custom or a system function.

Updating value suggestion

Linked servers suggestion

Linked servers suggestion is supported.

Linked servers suggestion

Linked server objects suggestion

The suggestion list shows all the existing objects for every linked server.

Linked server objects suggestion

ALTER objects suggestion

The suggestion list shows an object name depending on the ALTER statement type.

ALTER objects suggestion

DROP objects suggestion

The DROP statement behavior is the same as the ALTER statement.

DROP objects suggestion
Breadcrumb suggestion

Breadcrumb suggestion

Breadcrumb object suggestion is supported.

Column datatype suggestion in CREATE TABLE statement

The suggestion list shows all the available data types while creating a new table.

Column datatype suggestion in CREATE TABLE statement

Columns suggestion in ALTER TABLE statement

Extended suggestion syntax for the ALTER statement allows to see custom objects and available columns.

Columns suggestion in ALTER TABLE statement

CURSOR suggestion

The suggestion list shows all the available cursor variables in the CURSOR statements.

CURSOR suggestion

FETCH suggestion

The suggestion list shows custom variables in the FETCH statement.

FETCH suggestion

DELETE FROM suggestion

The suggestion list shows custom tables and views for the DELETE statement.

DELETE FROM suggestion

WHERE suggestion

The completion list shows available columns and scalar functions for a selected object in the DELETE statement.

WHERE suggestion

TRUNCATE suggestion

The completion list shows custom tables in the TRUNCATE statement.

TRUNCATE suggestion

Default schema suggestion

In case you do not specify a schema explicitly, the suggestion list shows objects from a default schema.

Default schema suggestion

Filtering objects by specified schema

In case you specify a schema explicitly, the suggestion list shows objects from the specified schema.

Filtering objects by specified schema

CTE suggestion

Common Table Expressions (CTE) suggestion is supported.

CTE suggestion

Recursive CTE suggestion

For the recursive CTE statements the suggestion list shows scalar functions, columns, and aliases.

Recursive CTE suggestion

Triggers suggestion

Triggers suggestion is available.

Prompt on Triggers

Virtual table suggestion

The suggestion list shows virtual tables (DELETED/INSERTED) in the trigger body.

Virtual table suggestion

Column suggestion for virtual tables

The suggestion list shows columns to which you refer using virtual tables (DELETED/INSERTED).

Column suggestion for virtual tables

Synonym suggestion

Synonyms suggestion for custom objects is supported.

Synonym suggestion

Query hints suggestion

You can specify a hint for the query optimizer.

Query hints suggestion

Table hints suggestion

You can use table hints.

Table hints suggestion

SQLCMD mode suggestion

The suggestion list shows variables in the SQLCMD mode.

SQLCMD mode suggestion

System variables suggestion

The suggestion list shows system variables in the places where a value is expected.

System variables suggestion

Label suggestion

If the script contains a label, the suggestion list shows one in the GOTO context.

Label suggestion

DBCC command suggestion

DBCC commands suggestion is supported.

DBCC command suggestion

Suggestion for hierarchyid datatypes

The suggestion list shows built-in methods for hierarchical data types.

Suggestion for hierarchyid datatypes

BULK INSERT suggestion

Extended syntax suggestion for the BULK INSERT statement is supported.

BULK INSERT suggestion

Stored procedures suggestion

The suggestion list shows stored procedures in the EXEC statement.

Stored procedures suggestion

MERGE suggestion

The suggestion list shows columns and aliases in the MERGE statement.

MERGE suggestion

RAISERROR suggestion

For the vast majority of T-SQL statements the suggestion list provides extended syntax prompts.

RAISERROR suggestion

PRINT suggestion

The suggestion list shows scalar functions and custom variables for the PRINT statement.

PRINT suggestion

DECLARE TABLE suggestion

Suggestion for the DECLARE TABLE statement is supported.

DECLARE TABLE suggestion

Table variable suggestion

The suggestion list shows table variables and columns.

Table variable suggestion

Temporary table suggestion

The suggestion list shows temporary tables variables and columns.

Temporary table suggestion

User and role suggestion

The suggestion list shows current users and roles for the current database.

User and role suggestion

Datatypes suggestion

The suggestion list shows the data types for variables.

Datatypes suggestion

User-defined table-type suggestion

The suggestion list displays user-defined tables and columns while you are writing a query.

User Defined Table Type Suggestion

CREATE INDEX suggestion

Use a suggestion while creating a nonclustered in-memory columnstore index for a SQL Server table.

CREATE INDEX Suggestion

SEQUENCE suggestion

The SEQUENCE suggestion is supported.

SEQUENCE suggestion

Column suggestion while declaring indexes

Columns are suggested when declaring indexes.

Column suggestion while declaring indexes

CROSS/OUTER APPLY suggestion

Suggestions are available in queries that include a correlated subquery.

Column suggestion while declaring indexes

Suggestion of objects declared in a script

Objects declared in a script are suggested.

Column suggestion while declaring indexes

JSON suggestion

JSON keywords are suggested.

Suggestion of objects in JSON statements