存储过程的用途是什么? [英] what is use of stored procedure?

问题描述

存储过程以及如何使用asp.net c#代码实现.

what is stored procedurce and how to use asp.net c# code implementation.

推荐答案

查看此处:存储过程和ASP .Net [^ ]

我不是ASP.Net开发人员.但是，我认为，如果您在此处的论坛和文章中进行搜索并使用Google，您应该会找到所需的内容.祝您好运.

Look here: Stored Procedures[^] and here Stored Procedures and ASP.Net[^]

I am not an ASP.Net developer. However, I think if you search here in the forums and articles and use Google you should find what you are looking for. Good luck.

存储过程是一组数据库命令，可以将它们组合在一起以实现某些结果.通常，我们编写命令以从数据库对象(例如，表，视图等)中插入，更新或删除数据.如果我们想实现这些功能中的任何一个或全部而不必重复编写这些命令，那么写一个当我们希望执行命令时可以调用的存储过程.
对于SQL Server，您应从以下类似内容开始:

Stored procedures are a group of database commands that are put together to achieve some results. Often, we write commands to insert, update or delete data from a database object (eg. table, view etc.) If we want to achieve any or all of these functionality without having to repeatedly write these commands, then is good to write a stored procedure which can be called when we want the command(s) executed.
for SQL server you start with something like this:

Create Procedure [Procedure_Name]
(
    @Parameter1 [Datatype], [Constraint],
    .
    .
    .
    etc
)
As
Begin

    some-Code (commands to execute)

End
Go

您可以通过传递必需的参数(如:exec Procedure_Name @ Parameter1，@ Parameter等)，在asp或任何位置调用该过程

you can called the procedure in you asp or wherever by passing the required parameter like :exec Procedure_Name @Parameter1,@Parameter, etc

为您提供良好的Wiki页面- ^ ]

为什么使用存储过程? [

Nice wiki page for you - Stored procedure[^]

Why Use Stored Procedures?[^]

这篇关于存储过程的用途是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！