The following SQL statements are different in the enterprise manager and the query result under the query analyzer.
Select * from table1 leftouter Join table2 on table1.no = Table2.no where table1.name! = Table2.name
For example, Table1, Table2 Table Table1: No Name1 Zhang 3 2 Li Si 3 King 5 Table2: No Name1 Li Si 2 Zhang 3
The results in the Enterprise Manager: No Name No Name1 Zhang 3 1 Li Si 2 Li Si 2 Zhang 3 3 King 5 NULL NULL
The results in the query analyzer are: 1 three 1 Li Si 2 Li Si 2 sheets
The statement automatically turns the statement in the Enterprise Manager:
Select * from table1 left outer join table2 on table1.no = Table2.no and table1.name! = Table2.name
Does the automatic change format of the Enterprise Manager make SQL semanties change? I don't know if you have encountered this problem. Write out for your reference, welcome to discuss. The result of SQL Server 2000 SP2 WINDOW2000 SP4.
