vs.net中存储过程使用方法研究

Research of Stored Procedure Technology Based on vs.net

主要分析在vs.net中怎样用存储过程来优化数据库访问并给出实例。具体包括用存储过程与用SQL语句的对比、使用带参存储过程以及通过存储过程进行数据库表的更新。最后给出几个在vs.net中使用存储过程的建议。

The paper introduces how to use stored procedure to optimize the Database access in vs.net and uses an example to describe this. In detail, it includes the comparison of simple stored procedure with SQL, stored procedure with parameters, and use stored procedure to update database table. After these, it gives out some advice about stored procedure in vs.net.