Tables and aliases

With sql server 2005, when i use a table's alias with the word "AS" like this:
- tablename AS aliasname
sqla 6.0.33 no longer recognizes the columns without the aliasname before, if pass the mouse over it does not display the pop-up detail, but if i remove the word "AS" like this:
- tablename aliasname
it resume operation.

Last edited by maxpesola on Tue Jul 12, 2011 5:03 am; edited 1 time in total

It does work for me. However, it does not for columns sq.id_table2 and sq.valami_mas when selecting from a subquery joined to a table like this:

	Code:
	SELECT t1.id_table1 ,t1.valami ,sq.id_table2 ,sq.valami_mas FROM dbo.table1 AS t1 INNER JOIN ( SELECT t2.id_table2 ,t2.valami_mas ,t2.id_table1 FROM dbo.table2 AS t2 ) AS sq ON sq.id_table1 = t1.id_table1

Try to not use the alias before the columnname in a simple query like this:

	Quote:
	SELECT * FROM tablename AS b WHERE columname=1

The columname does not have the popup.

I've misread that you were not using the aliasname.columname format, sorry. It really does not work when omitting the alias name. When joining tables and selecting (wherring:) columns that are present in some of the tables with the same name, that column name would be ambiguous, but then again, it could work with simple queries.

The hover-over popup for subquery columns does not work at all, regardless of the alias name and/or the AS keyword being present or not. The popup that shows when typing the names does contain the info, though.

	Quote:
	With sql server 2005, when i use a table's alias with the word "AS" like this: - tablename AS aliasname sqla 6.0.33 no longer recognizes the columns without the aliasname before, if pass the mouse over it does not display the pop-up detail, but if i remove the word "AS" like this: - tablename aliasname it resume operation.

Thank you very much for your feedback. I have logged this bug to your tracking system, ticket #SA0014915

	Quote:
	No hover-over info for subquery columns

In the current version, SQL Assistant is able to figure out column names from a subquery, but doesn't know their data types. For regular table and view columns it queries system catalog tables (see Columns query in the Options, on DB queries tab). For subquery based columns that method doesn't work and that's why data type hint is not displayed on mouse over subquery columns.

SysOp wrote:

	Quote:
	No hover-over info for subquery columns

In the current version, SQL Assistant is able to figure out column names from a subquery, but doesn't know their data types. For regular table and view columns it queries system catalog tables (see Columns query in the Options, on DB queries tab). For subquery based columns that method doesn't work and that's why data type hint is not displayed on mouse over subquery columns.

What about the info shown in the popup for selecting the columns? Where does it come from? Though there are no indication about keys or uniqueness, the popup clearly shows types for columns from sq subquery.

That's a good question, which I'm unable to asnwer. I will have to forward your questions to our develeopment team.

Also , if i add the WITH(NOLOCK) after the tablename the popup of colums does not work, like this simple query:

	Quote:
	SELECT * FROM tablename b WITH(NOLOCK) WHERE b.columname=1

Thank you. I have logged that too.

	SysOp wrote:
	That's a good question, which I'm unable to asnwer. I will have to forward your questions to our develeopment team.

Thank you very much.