insert 内容来自一个变量和select f1,count(f2) from t1 group by f1, 如何写?(50分)

P

piza

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #1

大意：
Insert INTO t2(F1, F2, F3)
SELECT T1.F1, COUNT(DISTINCT T1.F2),变量
FROM T1
GROUP BY T1.F1, T1.F2;

 

S

sonie

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #2

哪是在ms sql中可以这样
insert into t2(f1,f2,f3)
values(select t1.f1,count(distinct t1.f2),变量 from t1 group by f1,f2))

 

J

jjweb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #3

先给SQL里写上insert into 表名 (字段1,字段2) values G_code,:G_name)
然后用
parambyname('G_code').asstring:='0001';
parambyname('G_name').asstring:='张三';
给G_code和G_name附值
在打开库就等于
insert into 表名 (字段1,字段2) values ('0001','张三')

 

S

sportsman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #4

字符串拼接

 

P

piza

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #5

jjweb: 要插入的是多条记录
sonie: 我想是不是这样
MyVar:=Now;
with Query1 do begin
close;
with SQL do begin
clear;
` Add('Insert Into t2(f1,f2,f3) ');
Add('Values(Select ff1, COUNT(DISTINCT ff2) ,:MyVar);
???
Add(' FROM t1');
Add(' Group by ff1, :MyVar)');
???
ExecSQL;
end;
end;

 

S

sonie

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #6

不行,肯定不行
with Query1 do
begin
close;
with SQL do
begin
clear;`
Add('Insert Into t2(f1,f2,f3) ');
Add('Values(Select ff1, COUNT(DISTINCT ff2) ,:MyVar');
Add(' FROM t1');
Add(' Group by ff1, :MyVar)');
???这里有没有必要或者行不行，你再试试，应该是不要的
end;
parambyname('Myvar').AsDataTime=now;//这句才是真正的给参数赋值，你原来的那句myvar:=now是要不得的
ExecSQL;
end;

 

P

pxlei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-30

• #7

那个数据库?

 

J

jjweb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-30

• #8

重要的是用 parambyname('Myvar').asstring:='abcde';
然后在执行

 

G

ggqq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-30

• #9

query 里的sql 写上：Insert INTO t2(F1, F2, F3)
SELECT T1.F1, COUNT(DISTINCT T1.F2),:var
FROM T1 GROUP BY T1.F1, T1.F2

程序里写上 parambyname('var').asstring:='张三';

再 query.execute;

行了？

 

千

千中元

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-01

• #10

多人接受答案了。