本文介绍了具有相同ID的多插入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用相同的ID进行多次插入。我确实设法创建了有效的参数化查询,但是通过两次使用相同的参数(@projekt)仍然看起来有点难看。有人可以给小费吗?谢谢
我尝试过:
Hi, i am trying to do multiple insert with same id. I did manage to create parametrised query which is working, but still looks kinda ugly by using the same parameter (@projekt) twice. Can somebody gimme a tip ? Thank you
What I have tried:
insert into Forma (formaNazwa, FK_projektId)
values(
@forma1,
(select projektId from Projekt where projektNazwa = @projekt)
)
,
(
@forma2,
(select projektId from Projekt where projektNazwa = @projekt)
)
;
cmd1.Parameters.AddWithValue("@forma1",TextBoxProjectNameAdd.Text.ToString());
cmd1.Parameters.AddWithValue("@forma2",TextBoxProjectNameAdd1.Text.ToString());
cmd1.Parameters.AddWithValue("@projekt",TextBoxProjectNameAdd2.Text.ToString())
推荐答案
insert into Forma (formaNazwa, FK_projektId)
SELECT formaNazwa.Value,projektId
FROM Projekt
CROSS JOIN (VALUES (@forma1),(@forma2)) AS formaNazwa(Value)
WHERE projektNazwa = @projekt
这篇关于具有相同ID的多插入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!