简单sql语句

数据库中时间字段的类型是smalldatetime 
insert into shop(shopname,shoptype,shopuser,shopk,shopc,shopdisk,shopPrice1,shopPrice2,shoptime,ts,jp,tj,shopContent) values('" + bookname + "','" + bookclass + "','" + author + "','" + disk + "','" + ceshu + "','" + bookdx + "'," + price + "," + price + ",'" +DateTime .Parse (time) + "','" + tj + "','" + rx + "','" + dz + "','" + content + "')"; 
这条语句时间字段这么写'"+DateTime .Parse (time) + "'不对，应该怎么写

解决方案 »

  1.   

    convert(datetime,time)
    convert(varchar2(10),time,120)
      

  2.   

    insert into shop(shopname,shoptype,shopuser,shopk,shopc,shopdisk,shopPrice1,shopPrice2,shoptime,ts,jp,tj,shopContent) values('" + bookname + "','" + bookclass + "','" + author + "','" + disk + "','" + ceshu + "','" + bookdx + "'," + price + "," + price + ",'convert(varchar (10),'"+time+'",120) ','" + tj + "','" + rx + "','" + dz + "','" + content + "')"; 
      

  3.   

    + ",cast(" +DateTime .Parse (time).Tostring() + " as smalldatetime),'" + tj + "','" + rx + "','" + dz + "','" + content + "')"; 
    或
    + ",'" +DateTime .Parse (time).Tostring() + "','" + tj + "','" + rx + "','" + dz + "','" + content + "')";