insert into 语法错误?插入中有时间字段,数据库为SQLSERVER2000

Question

insert into register
(id,[indate],bh,name,sex,number,idtype,idnumber,cartype,carnumber,guestunit,visitunit,visitmaster,reserveid,worker)values(1,2005-2-4 10:12:39,1,"lxf","男",1,"身份证","210112760923401","辽L","17018","运输公司","供应总公司","圆珠笔",22,"王慧媛")总是提示: 在10附近有语法错误,不知道何解
不带引号的字段类型为int
2005-2-4 10:12:39  字段为:datetime    出错的就是说这个10附近有语法错误,郁闷!!!
焦急等待中 在线!!!

Answer 1

搞定，谢谢大家！！！
ssql3:='insert into   register  values('+
      inttostr(id1)+','+#39+
      datetimetostr(now)+#39+','+
      inttostr(bh1)+','+#39+
      name1+#39+','+#39+
      sex1+#39+','+
      number1+','+#39+
      idtype1+#39+','+#39+
      idnumber1+#39+','+#39+
      cartype1+#39+','+#39+
      carnumber1+#39+','+#39+
      guestunit1+#39+','+#39+
      visitunit1+#39+','+#39+
      visitmaster1+#39+','+
      reserveid1+','+#39+
      worker1+#39+')';