UC知道这样插入数据对吗？？
来源：百度知道 编辑：UC知道 时间：2024/06/14 08:04:12
sql = "INSERT INTO Discuss( UserId, Content, Posttime, NewsId) VALUES('" _
& UserId &"','" & Content & "','" & now() & "'," & Newsid & ")"
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]从字符串转换为 smalldatetime 数据类型时发生语法错误
怎么提示这个错误呀？？
& UserId &"','" & Content & "','" & now() & "'," & Newsid & ")"
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]从字符串转换为 smalldatetime 数据类型时发生语法错误
怎么提示这个错误呀？？
UserId是什么类型？如果是自动编号就不用写入了：
sql = "INSERT INTO Discuss(Content, Posttime, NewsId) VALUES('" & Content & "','" & now() & "'," & Newsid & ")"
如果是数值类型，则为：
sql = "INSERT INTO Discuss( UserId, Content, Posttime, NewsId) VALUES("& UserId &",'" & Content & "','" & now() & "'," & Newsid & ")"