需要一个存储过程来插入记录 [英] to need a stored procedure for inserting records

问题描述

嗨

我需要一个存储过程，一次单击即可插入多行.

请提供代码.

表名称:tbl_StudetntRights
参数:stdid，subjectId

如果我想插入1 1
1 2
1 3
在此先感谢

Hi

I need a stored procedure inserting multiple rows at one button click.

Please give the code.

Table name :tbl_StudetntRights
params : stdid,subjectId

If i want to insert 1 1
1 2
1 3
Thanks in advance

推荐答案

在此处 [ ^ ]

In addition to mkgoud''s Answer:

逻辑上的事情是将Array/List传递给您的存储过程.但是，存储过程不支持Array/List参数处理.因此，您将需要提出其他创新解决方案.有几种方法，请查看这篇文章 [

In addition to mkgoud''s Answer:

The logical thing to do is to pass Array/List to your store procedure. But, store procedure do not have a support for Array/List parameter handling. Thus you will need to come up with other innovative solutions. There are several way of doing this, take a look at this post[^].

这篇关于需要一个存储过程来插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！