如何在存储过程中使用Loop
LOOP statement
The LOOP statement repeats the execution of a statement or a group of statements.
Invocation
This statement can only be embedded in an SQL procedure. It is not an executable statement and cannot be dynamically prepared.
Authorization
No privileges are required to invoke the LOOP statement. However, the authorization ID of the statement must hold the necessary privileges to invoke the SQL statements that are embedded in the LOOP statement.
Syntax
>>-+——–+–LOOP–| SQL-routine-statement |–END LOOP–+——-+->
The LOOP statement repeats the execution of a statement or a group of statements.
Invocation
This statement can only be embedded in an SQL procedure. It is not an executable statement and cannot be dynamically prepared.
Authorization
No privileges are required to invoke the LOOP statement. However, the authorization ID of the statement must hold the necessary privileges to invoke the SQL statements that are embedded in the LOOP statement.
Syntax
>>-+——–+–LOOP–| SQL-routine-statement |–END LOOP–+——-+->
【如何在存储过程中使用Loop】相关文章
2. 在DELPHI中调用存储过程和使用内嵌SQL哪种方式更好
8. 存储过程和函数的区别
10. 一道SQL存储过程面试题
本文来源:https://www.mianshiwenti.com/a13384.html
进入下载页面
上一篇:汇智创新科技发展有限公司
下一篇:SQL语言面试题
﹝如何在存储过程中使用Loop﹞相关内容
- 存储过程的优缺点是什么
- 存储过程的优点有哪些
- shallow copy和deep copy的区别
- What\'s the difference between deep copy and shallow copy? (深拷贝与浅拷贝有什么区别)
- 我们在web应用开发过程中经常遇到输出某种编码的字符,如iso8859-1等,如何输出一个某种编码的字符串?
- 求职过程中比较常见的六大陷阱及相应对策
- Spring对多种ORM框架提供了很好的支持,简单描述在Spring中使用Hibernate的方法
- 网络编程中设计并发服务器,使用多进程与多线程,请问有什么区别?
- 软件测试LoadRunner面试题:What is the difference between standard log and extended log?
- 如何在Cookie里面保存Unicode和国际化字符