今天发现sql server在查询语句上有一些平时忽略的小细节,
eg:
1.前提 :customer_roomNum是varchar类型,但是
SELECT * FROM customer WHERE customer_roomNum='004'错误,而应该
SELECT * FROM customer WHERE customer_roomNum=004,可以看到,不能加单引号,即使是varchar类型
2.前提:customer_name是varchar类型
SELECT * FROM customer WHERE customer_name="小李",错误,应该
SELECT * FROM customer WHERE customer_name='小李',可以看到,应该为单引号
完(因为这些小问题,后期代码中用sql语句时出现了莫名其妙的问题,不能一时反应过来,也是想了半天才发现,所以小细节也要注意啊)