How to Use Procedure
来源:互联网 发布:linux vi显示行数 编辑:程序博客网 时间:2024/05/16 13:55
SQL give you the capability to define your own procedure,
Here is an example.
create procedure Tonytest
--after create this Procedure, you can use alter instead of create to modify it--
as
Begin
Select student_number as pre_stdn from students
update students set student_number=student_number+1 where student_number is not null
--add 1 on all student numbers--
select student_number as alt_stdn from students
End
After this define, use this to run procedure:
Execute Tonytest;
You can see it has been changed.
If you want to go check all Procedure you made, please use:
select ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE='PROCEDURE'
- How to Use Procedure
- How to use SQL store procedure to trace SQL performance instead of SQL profiler
- How To Use a DataReader Against an Oracle Stored Procedure in Visual C# .NET
- how use procedure with sybase database?
- How To Use DataGird
- how to use typedef
- how to use gz
- How to use chkconfig
- How to use ,,,,
- how to use dialog
- How to use UIDs
- How to use dmalloc
- How to use abld
- How to use BSTR
- How to use Ant
- how to use mstsclib
- how to use gcc
- how to use thread
- js 中数据类型和对象的相关
- Android开发之图片处理框架(二)
- 2016CCPC-Fianl宁波流水账
- Oracle基础
- 权限控制
- How to Use Procedure
- 计算机学习的三条主线
- 细数RxBinding的各种优雅响应式绑定
- linux命令行日常系快捷键
- 怎么查看Oracle数据库中的所有用户名
- Java面向对象
- Interlude: Troubleshooting for 'no corresponding BEGIN TRANSACTION'
- eclipse使用egit插件管理git库
- VB调用摄像头录像,拍照,保存