INFO: Table Alias Syntax Checking in SQL 6.0 and Later is ANSI-Compliant

MORE INFORMATION

As an example of the difference in behavior, assume this script has been executed:

   use pubs
   go
   select authors.au_lname from authors aa where au_lname like 'W%'
   go
   select aa.au_lname from authors aa where authors.au_lname like 'W%'
   go
				

In both SELECT statements, notice the use of "authors" to qualify the column "au_lname" even though an alias, "aa", has been provided to substitute for the table name. On previous versions of Microsoft SQL Server, the results of each of these SELECT statements is:

   au_lname
   ----------------------------------------
   White

   (1 row(s) affected)
				

Whereas on Microsoft SQL Server 6.0 and later the following error message is given:

In SQL Server 6.0 and later the following SELECT statement is equivalent to the ones above:

   select aa.au_lname from authors aa where aa.au_lname like 'W%'
				

This behavior is NOT affected by the current setting of Trace Flag 204.