社区
MS-SQL Server
帖子详情
About Procedure
Kanfu
2000-03-09 05:04:00
我以前从未接触过存储过程,现在要用存储过程,各路高手,用(编写)存储过程有哪些注意事项和碰到的一些比较特殊的问题的处理方法,能不能共享一下.
...全文
153
5
打赏
收藏
About Procedure
我以前从未接触过存储过程,现在要用存储过程,各路高手,用(编写)存储过程有哪些注意事项和碰到的一些比较特殊的问题的处理方法,能不能共享一下.
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
5 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
Kanfu
2000-03-11
打赏
举报
回复
我在存储过程中从未用过Commit Trans他是不是自动提交的.
GoldenLion
2000-03-10
打赏
举报
回复
同意,其实重要的是stored procedure内的事务嵌套有时会搞错。注意Commit Trans,ROLLBACK,SAVE TRANS,##TRANSCOUNT的涵义。
929
2000-03-10
打赏
举报
回复
上面两位所说完全同意。另外,在存储过程中每一条语句执行后,都有可能会出错。最好在每条语句后,判断@@ERROR是否不为零,若是的话,转到错误处理中进行处理。一般错误处理中都有执行ROLLBACK来实现。建议看一下《SQL SERVER开发指南》一书。里面有完整的关于存储过程中事务处理的模板文件。另外,SQL SERVER BOOK ONLINE也是一个很好的参考资料。
dthl
2000-03-09
打赏
举报
回复
要考虑是否在Store procedure中加事务,因为有可能在外围已启动事务
在SQL SERVER中可采用多阶段事务 多阶段提交
LaoZheng
2000-03-09
打赏
举报
回复
少用Select Count(*) frm Table语句.影响速度
select * from Table语句会影响 Result的值
select * from Table语句写成select field1,field2 .. from Table 会提高远行速度
这是一个关于 matl
ab
的 打开和写入的简单程序,This is an open matl
ab
and write
ab
out the simple
procedure
这是一个关于 matl
ab
的 打开和写入的简单程序,This is an open matl
ab
and write
ab
out the simple
procedure
MySql存储过程编程.chm
MySQL Stored
Procedure
Programming Advance Praise for MySQL Stored
Procedure
Programming Preface Objectives of This Book Structure of This Book What This Book Does Not Cover Conventions Used in This Book Which Version? Resources Avail
ab
le at the Book's Web Site Using Code Examples Safari® En
ab
led How to Contact Us Acknowledgments Part I: Stored Programming Fundamentals Chapter 1. Introduction to MySQL Stored Programs Section 1.1. What Is a Stored Program? Section 1.2. A Quick Tour Section 1.3. Resources for Developers Using Stored Programs Section 1.4. Some Words of Advice for Developers Section 1.5. Conclusion Chapter 2. MySQL Stored Programming Tutorial Section 2.1. What You Will Need Section 2.2. Our First Stored
Procedure
Section 2.3. Vari
ab
les Section 2.4. Parameters Section 2.5. Conditional Execution Section 2.6. Loops Section 2.7. Dealing with Errors Section 2.8. Interacting with the Dat
ab
ase Section 2.9. Calling Stored Programs from Stored Programs Section 2.10. Putting It All Together Section 2.11. Stored Functions Section 2.12. Triggers Section 2.13. Calling a Stored
Procedure
from PHP Section 2.14. Conclusion Chapter 3. Language Fundamentals Section 3.1. Vari
ab
les, Literals, Parameters, and Comments Section 3.2. Operators Section 3.3. Expressions Section 3.4. Built-in Functions Section 3.5. Data Types Section 3.6. MySQL 5 "Strict" Mode Section 3.7. Conclusion Chapter 4. Blocks, Conditional Statements, and Iterative Programming Section 4.1. Block Structure of Stored Programs Section 4.2. Conditional Control Section 4.3. Iterative Processing with Loops Section 4.4. Conclusion Chapter 5. Using SQL in Stored Programming Section 5.1. Using Non-SELECT SQL in Stored Programs Section 5.2. Using SELECT Statements with an INTO Clause Section 5.3. Creating and Using Cursors Section 5.4. Using Unbounded SELECT Statements Section 5.5. Performing Dynamic SQL with Prepared Statements Section 5.6. Handling SQL Errors: A Preview Section 5.7. Conclusion Chapter 6. Error Handling Section 6.1. Introduction to Error Handling Section 6.2. Condition Handlers Section 6.3. Named Conditions Section 6.4. Missing SQL:2003 Features Section 6.5. Putting It All Together Section 6.6. Handling Stored Program Errors in the Calling Application Section 6.7. Conclusion Part II: Stored Program Construction Chapter 7. Creating and Maintaining Stored Programs Section 7.1. Creating Stored Programs Section 7.2. Editing an Existing Stored Program Section 7.3. SQL Statements for Managing Stored Programs Section 7.4. Getting Information
Ab
out Stored Programs Section 7.5. Conclusion Chapter 8. Transaction Management Section 8.1. Transactional Support in MySQL Section 8.2. Defining a Transaction Section 8.3. Working with Savepoints Section 8.4. Transactions and Locks Section 8.5. Transaction Design Guidelines Section 8.6. Conclusion Chapter 9. MySQL Built-in Functions Section 9.1. String Functions Section 9.2. Numeric Functions Section 9.3. Date and Time Functions Section 9.4. Other Functions Section 9.5. Conclusion Chapter 10. Stored Functions Section 10.1. Creating Stored Functions Section 10.2. SQL Statements in Stored Functions Section 10.3. Calling Stored Functions Section 10.4. Using Stored Functions in SQL Section 10.5. Conclusion Chapter 11. Triggers Section 11.1. Creating Triggers Section 11.2. Using Triggers Section 11.3. Trigger Overhead Section 11.4. Conclusion Part III: Using MySQL Stored Programs in Applications Chapter 12. Using MySQL Stored Programs in Applications Section 12.1. The Pros and Cons of Stored Programs in Modern Applications Section 12.2. Advantages of Stored Programs Section 12.3. Disadvantages of Stored Programs Section 12.4. Calling Stored Programs from Application Code Section 12.5. Conclusion Chapter 13. Using MySQL Stored Programs with PHP Section 13.1. Options for Using MySQL with PHP Section 13.2. Using PHP with the mysqli Extension Section 13.3. Using MySQL with PHP Data Objects Section 13.4. Conclusion Chapter 14. Using MySQL Stored Programs with Java Section 14.1. Review of JDBC Basics Section 14.2. Using Stored Programs in JDBC Section 14.3. Stored Programs and J2EE Applications Section 14.4. Using Stored
Procedure
s with Hibernate Section 14.5. Using Stored
Procedure
s with Spring Section 14.6. Conclusion Chapter 15. Using MySQL Stored Programs with Perl Section 15.1. Review of Perl DBD::mysql Basics Section 15.2. Executing Stored Programs with DBD::mysql Section 15.3. Conclusion Chapter 16. Using MySQL Stored Programs with Python Section 16.1. Installing the MySQLdb Extension Section 16.2. MySQLdb Basics Section 16.3. Using Stored Programs with MySQLdb Section 16.4. A Complete Example Section 16.5. Conclusion Chapter 17. Using MySQL Stored Programs with .NET Section 17.1. Review of ADO.NET Basics Section 17.2. Using Stored Programs in ADO.NET Section 17.3. Using Stored Programs in ASP.NET Section 17.4. Conclusion Part IV: Optimizing Stored Programs Chapter 18. Stored Program Security Section 18.1. Permissions Required for Stored Programs Section 18.2. Execution Mode Options for Stored Programs Section 18.3. Stored Programs and Code Injection Section 18.4. Conclusion Chapter 19. Tuning Stored Programs and Their SQL Section 19.1. Why SQL Tuning Is So Important Section 19.2. How MySQL Processes SQL Section 19.3. SQL Tuning Statements and Practices Section 19.4.
Ab
out the Upcoming Examples Section 19.5. Conclusion Chapter 20. Basic SQL Tuning Section 20.1. Tuning T
ab
le Access Section 20.2. Tuning Joins Section 20.3. Conclusion Chapter 21. Advanced SQL Tuning Section 21.1. Tuning Subqueries Section 21.2. Tuning "Anti-Joins" Using Subqueries Section 21.3. Tuning Subqueries in the FROM Clause Section 21.4. Tuning ORDER and GROUP BY Section 21.5. Tuning DML (INSERT, UPDATE, DELETE) Section 21.6. Conclusion Chapter 22. Optimizing Stored Program Code Section 22.1. Performance Characteristics of Stored Programs Section 22.2. How Fast Is the Stored Program Language? Section 22.3. Reducing Network Traffic with Stored Programs Section 22.4. Stored Programs as an Alternative to Expensive SQL Section 22.5. Optimizing Loops Section 22.6. IF and CASE Statements Section 22.7. Recursion Section 22.8. Cursors Section 22.9. Trigger Overhead Section 22.10. Conclusion Chapter 23. Best Practices in MySQL Stored Program Development Section 23.1. The Development Process Section 23.2. Coding Style and Conventions Section 23.3. Vari
ab
les Section 23.4. Conditional Logic Section 23.5. Loop Processing Section 23.6. Exception Handling Section 23.7. SQL in Stored Programs Section 23.8. Dynamic SQL Section 23.9. Program Construction Section 23.10. Performance Section 23.11. Conclusion
Ab
out the Author Colophon Index
For-Testing
For Testing, to make myself more clear
ab
out the
procedure
.
extrusion theory
extrusion theory,the
procedure
to handle the machine to extrude,the theory to learn
ab
out the vari
ab
le factors of the extrusion polymer
PL/SQL详解 从入门到精通 英文版
This is a book
ab
out writing stored
procedure
s for an Oracle dat
ab
ase. A stored
procedure
in this context is a generic term for a program written in the
Procedure
Language extension for SQL (PL/SQL) that is stored inside the dat
ab
ase when it is compiled. This means that you can then execute the program from inside the dat
ab
ase. Why would you want to do that? Because your program will run faster inside the dat
ab
ase.
MS-SQL Server
34,590
社区成员
254,589
社区内容
发帖
与我相关
我的任务
MS-SQL Server
MS-SQL Server相关内容讨论专区
复制链接
扫一扫
分享
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章