Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio 14.0.0-beta-28
Build #: 32908
Built on: 2013-Jun-17 05:04:51 PM
Operating Environment: Windows 8 (6.2, x86)
Database version:Microsoft SQL Azure (RTM) - 11.0.9041.138
Right click on any database -> Query_Builder->Select any table from drop down->click on Add button->Now in query builder window the generated script will have table name two times.
|
|
24 KB
Does this problem also occur in v13?
This is the way ADS behaves from v6.5.
The readability of a SELECT statement can be improved by giving a table an alias, also known as a correlation name or range variable. A table alias can be assigned either with or without the AS keyword
Does the Query Builder give you any error when you try to execute ?
This is the way ADS behaves from v6.5.
The readability of a SELECT statement can be improved by giving a table an alias, also known as a correlation name or range variable. A table alias can be assigned either with or without the AS keyword
Does the Query Builder give you any error when you try to execute ?
@Sachin : Yes We have same issue in v13.
@Tariq: No it executes successfully in Query Builder.
@Sachin : Yes We have same issue in v13.
@Tariq: No it executes successfully in Query Builder.
This extra name is an alias to the table. If you disable "quoted identifiers" in the filters on the toolbar it will remove the alias.
This is done as designed. I can't remember the exact reseason we did this, but Kin-Hong might remember. I think it had something to do with table names having spaces or special characters, so if you quote identify them we needed to reference columns with an alias.
This extra name is an alias to the table. If you disable "quoted identifiers" in the filters on the toolbar it will remove the alias.
This is done as designed. I can't remember the exact reseason we did this, but Kin-Hong might remember. I think it had something to do with table names having spaces or special characters, so if you quote identify them we needed to reference columns with an alias.
Issue #9408 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Does this problem also occur in v13?