| Author |
Message |
lis_s
Joined: 14 Mar 2013
Posts: 2
Country: Russian Federation |
|
 Automatically add "AS" before table alias |
 |
Hi all!
Is there any way to tell SA to put "AS" before aliases?
For example:
I need the following query
 |
 |
select * from MyTable
|
to be formatted like this
|
|
select * from MyTable as mt
|
|
|
| Thu Mar 14, 2013 10:43 am |
  |
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7951
|
|
| |
|
Options dialog -> DB Options table -> select SQL Assistance type on the left -> Expand Auto complete ... section on the right. -> Auto Add Aliases from "Yes" to "Yes (with AS keyword)" -> click OK button
|
|
| Thu Mar 14, 2013 10:38 pm |
|
|
lis_s
Joined: 14 Mar 2013
Posts: 2
Country: Russian Federation |
|
| |
|
 |
|
Options dialog -> DB Options table -> select SQL Assistance type on the left -> Expand Auto complete ... section on the right. -> Auto Add Aliases from "Yes" to "Yes (with AS keyword)" -> click OK button |
Thanks a lot!
|
|
| Fri Mar 15, 2013 1:20 am |
|
|
Olegon
Joined: 07 Sep 2009
Posts: 40
|
|
| |
|
Doesn't work with joins :(
Example:
|
|
select
*
from
dbo.Contractors as c
inner join dbo.Banks b
on
b.contractor_rid = c.record_id |
After I wrote "inner join" I chose table name from the joins list. Table alias added without "as".
|
|
| Thu Apr 04, 2013 7:28 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7951
|
|
| |
|
Thank you. I will log this issue to our support system
|
|
| Thu Apr 04, 2013 8:01 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2167
|
|
| |
|
|
|
Doesn't work with joins :(
Example:
|
|
select
*
from
dbo.Contractors as c
inner join dbo.Banks b
on
b.contractor_rid = c.record_id |
After I wrote "inner join" I chose table name from the joins list. Table alias added without "as". |
Strange indeed. It works properly when selecting the table from joins list but fails when selecting the join condition.
|
|
| Thu Apr 04, 2013 8:28 am |
|
|
|
