问题描述
我有一个SQL表，其中一个col是Material(INT).
现在，我的任务是我想将一系列材料放入ListBox，然后选择其中一些材料，然后将其插入到我的表格中.
例如:
varchar ---''a，b，c，d''---插入了为什么bcz用单引号我们
传递了N个值，表示将其视为单个
参数.
类似地
int --- 1,2,3,4 ---只需要一次插入到我的表中即可.
谁能帮我做到这一点..
在此先感谢...
Hi,
I have a SQL Table , in that one of the col is Material (INT).
Now, My task is i want to take a list of materials into ListBox, and then i select some of them, and then insert in to my table is it possible.
for ex:
varchar --- ''a,b,c,d'' --- its inserted why bcz with in the single quotation we
are passing N no.of values means it''s consider as a single
parameter.
similarly
int --- 1,2,3,4 --- has to be inserted into my table in a single insertion only.
can any one help me to do this..
Thanks in advance...
推荐答案
这篇关于SQL中的插入问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！