有效的查询参数: 1.不要对资料栏位做运算: 推荐第二种写法: SELECT * FROM student WHERE sName + ' , ' + phone = ' DuoDuo,456 256-89 ' GO SELECT * FROM student WHERE sName = ' DuoDuo ' and phone = ' 456 256-89 2. 不要使用负向查询 推荐使用第二种写法: SELECT * FROM student WHERE sAge != 0 GO SELECT * FROM student WHERE sAge > 0 OR sAge < 0 3. 不要对资料栏位使用函数 推荐使用第二种写法: SELECT * FROM student WHERE SUBSTRING (sName, 1 , 1 ) = ' D ' GO SELECT * FROM student WHERE sName LIKE ' D% '