SQL = "INSERT into test_data(piece_id ,x,y,h) values ("2003009","12","15","16") "
-->
SQL = "INSERT into test_data(piece_id ,x,y,h) values ('2003009','12','15','16') "
-->
SQL = "INSERT into test_data(piece_id ,x,y,h) values ('2003009','12','15','16') "
解决方案 »
- Order by排序问题
- sql 根据客户id按月统计报表
- 一个很简单的查询总是提示算术溢出,请大家指教,谢谢
- 新手求一条SQL语句怎么写,mssql
- 关于临时表的小问题???
- 一个Sql存储过程,请教一下老师
- 问个白痴问题
- 字段长度有影响吗?肯定给分!!
- 关于存储过程调用
- 请教一个SQlserver问题,ADSL上网的机器怎么访问该SQLSERVER的数据。(
- 修改列的数据类型时出错,如果列为text类型,alter table mytable alter mycolumn int/float,如果列为int或float类型,alter table mytable
- 如何将一个服务器数据库中的表导入到另一个服务器数据库
Dim cnn As ADODB.Nonnection
Dim SQL As String
Dim sTokens() As String
Set cnn = New ADODB.Connection
cnn.Open ConnectString
SQL = "INSERT into test_data(piece_id ,x,y,h) values ('2003009','12','15','16') "
sTokens = Split(SQL)
If InStr("INSERT,DELETE,UPDATE", _
UCase$(sTokens(0))) Then
cnn.Execute SQL
End If
End SubPublic Function ConnectString() _
As String
ConnectString = "FileDSN=gwj.dsn;UID=sa;PWD="
End Function
Dim cnn As ADODB.Nonnection
Dim SQL As String
Dim sTokens() As String
Set cnn = New ADODB.Connection
cnn.Open ConnectString
SQL = "INSERT into test_data(piece_id ,x,y,h) values (2003009,12,15,16) "
sTokens = Split(SQL)
If InStr("INSERT,DELETE,UPDATE", _
UCase$(sTokens(0))) Then
cnn.Execute SQL
End If
End SubPublic Function ConnectString() _
As String
ConnectString = "FileDSN=gwj.dsn;UID=sa;PWD="
End Function
x,y,h是int
SQL = "INSERT into test_data(piece_id ,x,y,h)
select '"& text1.text &"',cast('"& text2.text & "' as int) " &",15,16)"