![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
文章平均质量分 80
RaymondXie
这个作者很懒,什么都没留下…
展开
-
Database performance optimization
1. Using Store-procedure instead of SQL code in the programStore procedures can improve performance. Many tasks are implemented as a series of SQL statements. COndirional logic applied to the resul原创 2005-03-24 03:02:00 · 839 阅读 · 0 评论 -
Understanding Stored Procedure
The reasons to use Stored Procedure: simplicity, security, performance1. To simplify complex operations by encapsulating processes into a single easy-to-use unit2. To ensure data consistency by not re原创 2005-03-23 21:15:00 · 900 阅读 · 0 评论 -
SQL Transactions with the SqlTransaction Class (ZT)
SQL Transactions with the SqlTransaction Class [ printer friendly ] Stats Rating: 4.69 out of 5 by 29 users Submitted: 05/08/02 Andrew Ma (ajmaonline@hotmail.com) IntroductionTransactions. What转载 2005-03-23 20:28:00 · 1219 阅读 · 0 评论 -
ACID rule for transaction
ACID rule for transaction:Atomic: it is one unit of work and doesnot dependent on previous and following transactionsConsistent: data is either commited or roll back, no "in-between" case where someth原创 2005-03-23 21:53:00 · 1160 阅读 · 0 评论 -
SQL Server 2000 Security - Part 2 (Authentication)
SQL Server 2000 Security - Part 2 (Authentication)By Marcin Policht Access to SQL Server resources is controlled by two separate mechanisms. The first one is authentication, which determines the ident原创 2005-03-23 22:08:00 · 1073 阅读 · 0 评论