I want to return multiple records from table on dynamic conditions through a stored procedures.
我想通过存储过程从表中返回动态条件的多个记录。
1 个解决方案
#1
Yes. Each SELECT delivers one "result set" of any number of "rows". The calling code must have a loop to grab the resultsets. Within that, parse the rows just as you would for an ordinary SELECT.
是。每个SELECT提供任意数量“行”的一个“结果集”。调用代码必须有一个循环来获取结果集。在其中,解析行就像普通SELECT一样。
The details depend on the language you are using.
详细信息取决于您使用的语言。
#1
Yes. Each SELECT delivers one "result set" of any number of "rows". The calling code must have a loop to grab the resultsets. Within that, parse the rows just as you would for an ordinary SELECT.
是。每个SELECT提供任意数量“行”的一个“结果集”。调用代码必须有一个循环来获取结果集。在其中,解析行就像普通SELECT一样。
The details depend on the language you are using.
详细信息取决于您使用的语言。