How can we help you today? How can we help you today?

How to enable use of AS only for Columns and not Tables

How do I set SQL Prompt to do this:

SELECT T1.col1 AS 'Col1'
FROM TABLE1 T1


and NOT this:
SELECT T1.col1 AS 'Col1'
FROM TABLE1 AS T1
EdCarden
0

Comments

4 comments

Sort by
  • TomW
    Hi @EdCarden

    In order to achieve this, you'll need to set the following options. The first one is under the "Aliases" tab in the options, whereas the second one is under "Styles".



    Let me know if you have anymore problems.

    Thanks,
    Tom
    TomW
    0
  • EdCarden
    @TomW

    Ive never looked at the Styles feature before because I felt t was never flexible enough to suit my needs but its close. 

    I want to ask another Q but I can;t figure out how t post T-SQL code here so that its aligned correctly and presented here the same way it looks in SQL Server Mgt Studios query
    EdCarden
    0
  • TomW
    Hi @EdCarden

    Your best bet is likely to be to get in touch with our support team who can help you get a solid reproduction of your issue.

    Thanks,
    Tom
    TomW
    0
  • EdCarden
    TomW said:
    Hi @EdCarden

    Your best bet is likely to be to get in touch with our support team who can help you get a solid reproduction of your issue.

    Thanks,
    Tom
    Tom - Does this mean there is NO way in these forums to post T-SQL code such that its no re-formatted by the page in order to properly show an example of some SQL code? I would assume there is and its just not clear on how to since this is a feedback for tool on SQL development.
    EdCarden
    0

Add comment

Please sign in to leave a comment.