ADO 如何执行多条语句? 用的是sql server 2000 1.建立与database1的连接conn2.将多条语句写入字符串用分号隔开3.conn.execute 字符串 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 dim Cnn As New ADODB.ConnectionSQLstr = "use database1 ;go; insert into t1(code,date,message) ;select ID,Time,PA from database2..t2 ;insert into t3(itemno,partno) ;select Item ,Mode,from database2..t4 "Cnn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=database1;Data Source=192.168.2.123"Cnn.Execute SQLstr运行时报错啊? dim Cnn As New ADODB.Connection dim Sql stringSQLstr = "insert into t1(code,date,message) select ID,Time,PA from database2..t2 ;insert into t3(itemno,partno) select Item ,Mode,from database2..t4 " Sql = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=database1;Data Source=192.168.2.123" Cnn.open SqlCnn.Execute SQLstr dim Cnn As New ADODB.Connection dim Sql stringSQLstr = "insert into t1(code,date,message) select ID,Time,PA from database2..t2 ;insert into t3(itemno,partno) select Item ,Mode,from database2..t4 " Sql = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=database1;Data Source=192.168.2.123" Cnn.open SqlCnn.Execute SQLstr quite right! 初学问题请教 数据库两个表数据合并 SQLServer2000的存储过程 具有挑战性的SQL 语句你会吗 ? 判断插入数据合法性的问题? Run DBCC CHECKTABLE 用SQL能否实现向列里追加数据? sqlserver2000 存储过程分页的问题 急!!高手来~~ 存储过程返回值问题,在线等!!! 求一条SQL语句,各为大虾快来指点我一下 关于NULL的问题! 求一个‘SQL’语句来执行需要输入的值
SQLstr = "use database1 ;go; insert into t1(code,date,message) ;select ID,Time,PA from database2..t2 ;insert into t3(itemno,partno) ;select Item ,Mode,from database2..t4 "
Cnn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=database1;Data Source=192.168.2.123"
Cnn.Execute SQLstr
运行时报错啊?
dim Cnn As New ADODB.Connection
dim Sql string
SQLstr = "insert into t1(code,date,message) select ID,Time,PA from database2..t2 ;insert into t3(itemno,partno) select Item ,Mode,from database2..t4 "
Sql = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=database1;Data Source=192.168.2.123"
Cnn.open Sql
Cnn.Execute SQLstr
dim Sql string
SQLstr = "insert into t1(code,date,message) select ID,Time,PA from database2..t2 ;insert into t3(itemno,partno) select Item ,Mode,from database2..t4 "
Sql = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=database1;Data Source=192.168.2.123"
Cnn.open Sql
Cnn.Execute SQLstr quite right!