请问这条SQL语句有什么错?
tb_Image数据表中的Image字段位varchar类型,date为datetime类型。
mFileName = "abc.jpg ";
string sqlstr = "insert into tb_Image(Image,date) values( 'upFile\\ " + mFileName + " ',now) ";
执行时老是通不过,Why? 谢谢!
------解决方案--------------------string sqlstr = "insert into tb_Image(Image,[date]) values( 'upFile\\ " + mFileName + " ',getdate()) ";