W wxj9527 Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-09 #1 如题,为什么会出错? 一次查如多条的insert 语句怎么写>? 不用insert into ``select
李 李翔鹏 Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-09 #2 insert into test(f1,f2) values (23,32)insert into test(f1,f2) values(45,12)insert into test(f1,f2) values(87,23)
insert into test(f1,f2) values (23,32)insert into test(f1,f2) values(45,12)insert into test(f1,f2) values(87,23)
W wxj9527 Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-09 #3 要求用一条语句实现....mysql中可以insert into test(f1,f2) values (23,32),(45,12),(87,23)为什么SQL SERVER不行? SQL SERVER应怎么写?
要求用一条语句实现....mysql中可以insert into test(f1,f2) values (23,32),(45,12),(87,23)为什么SQL SERVER不行? SQL SERVER应怎么写?
S smlabc Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-09 #4 insert into test(f1,f2) values (23,32);insert into test(f1,f2) values(45,12);insert into test(f1,f2) values(87,23);中间用;号就可以一次运行
insert into test(f1,f2) values (23,32);insert into test(f1,f2) values(45,12);insert into test(f1,f2) values(87,23);中间用;号就可以一次运行
W wxj9527 Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-09 #5 这个我知道````我必须要用一条语句.因为字段个数和values的个数都不确定...上面那个只是个例子...
M mcs_5152 Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-10 #6 insert into test(f1,f2)select (f1,f2) from tableX
K kaida Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-11 #7 insert into test(f1,f2) select 23,32 union all select 45,12 union allselect 87,23
Q qdzb Unregistered / Unconfirmed GUEST, unregistred user! 2009-01-13 #9 insert into test(f1,f2)select 23,32 from dualunion allselect 45,12 from dual...
