摘要：本来以为 SELECT * FROM [Tbl_Teacher] WHERE LEN([Name])<1 行的，谁知道查不出来。再试：SELECT * FROM [Tbl_Teacher] WHERE [Name]=NULL 也不行，还是查不出来，，也没有出错。最后用：SELECT * FROM [Tbl_Teacher] WHERE [Name] IS NULL 查出来了。结论：查询字段值... 阅读全文

摘要：原SQL语句：SELECT TOP 10 * FROM [Order] WHERE [ID] NOT IN(SELECT TOP 6000 [ID] FROM [Order] ORDER BY [ID] DESC) ORDER BY [ID] DESC我在SQLSERVER的查询分析器上运行上面的SQL语句，速度挺快，但我在ACCESS的查询上却让我的机子死机（接近死机，哈哈哈哈！）。到底是我的S... 阅读全文