A common data procedure that can be called by many Web applications.
Programmatic access to a database

備份
***Return records
***Return value
***Perform action

程式 邏輯

presentation  logic data layers

商業邏輯 改變
會變動的邏輯 放在stored procedure

SP 有個很大的缺點

VB.net

SP 跟Vendor 有關完全不相容

------------------------------
COM binaray interface

--------------------------------

Return records
Return value

1.可以放在server上大家call
2.比較快

ADO .net 會先把語法，解析一遍，最佳化，用索引，compile --> execution --> SQL

Stored Procedure 第一次 run , 以後就不用

------------------------------------

***Modular programming
***Distribution of work
***Database security (可以設安全性 user )
***Reduced network traffic
***Faster execution 快一點
***Provid flexibility (彈性較高)