帮忙看看sql 的问题(100分)

S

shanliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #1

insert into xscjb(xh,xm,xueqi,bz)
values((select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2),(select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2
and zyh=:zyh_2 and nj=:nj_2),:kch_2,:c_xq_2,:bz_2)

 

A

Adnil

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #2

insert into xxx(field1, field2...) select field1, field2... from .....where....

两边的列的数量和类型要对应

 

J

jinmen

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #3

insert into xscjb(xh,xm.xueqi,bz)
select xh
from xsxcb
where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2 and nj=:nj_2,
:kch_2,:c_xq_2,:bz_2

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #4

insert into xscjb(xh,xm,xueqi,bz)
select xh,xh,:kch_2,:c_xq_2,:bz_2
from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2 and nj=:nj_2

 

无

无疯无禄

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #5

(xh,xm,xueqi,bz)
这四个字段
((select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2),(select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2
and zyh=:zyh_2 and nj=:nj_2),:kch_2,:c_xq_2,:bz_2)
这里有五个值

 

S

shanliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #6

我写错了 是：
insert into xscjb(xh,xm,kch,xueqi,bz)
values((select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2),(select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2
and zyh=:zyh_2 and nj=:nj_2),:kch_2,:c_xq_2,:bz_2)
我在DELPHI中写的想在xsxcb 中取数据写入xscjb中，并且是批量的写

 

王

王公子

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #7

这样当然不行啦,要批量执行,不不要用values,insert into 后面直跟一条查询,
试一下这样
insert into xscjb(xh,xm,kch,xueqi,bz)
select (select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2),(select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2
and zyh=:zyh_2 and nj=:nj_2),:kch_2,:c_xq_2,:bz_2 from xsxcb

 

J

jsxjd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #8

如果你的 子 select 返回一个值，应该没问题。
但返回多个不能这样写

 

S

shanliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #9

:kch_2,:c_xq_2,:bz_2 不是在xsxcb，我想在程序中动态的改变

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #10

select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2),select xh from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2),
這兩句一樣，為什麼要定兩次？select xh,xh from xsxcb where ...可以不?

insert into table
select a.column,b.column,:values from tablea a , tableb b where a.column1=b.column1 and ....

 

S

shanliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-24

• #11

这样写：
insert into xscjb(xh,xm,kch,xueqi,bz)
select xh xm from xsxcb where zdh=:zdh_2 and cch=:cch_2 and zyh=:zyh_2
and nj=:nj_2
kch,xueqi,bz，不在任何表中，我要在程序中动态的写入，格式是什么呀！我是老不能
同时插入

 

S

shanliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-30

• #12

接受答案了.