如何在sql server中编写存储过程以及如何在前端调用它并给我一个简单的例子 [英] How to write Stored Procedure in sql server and how to call that in front end and give me simple example

问题描述

我遇到了存储过程的问题，我想知道如何在sql server中编写存储过程以及如何在前端调用它并给我一个简单的例子，如插入，更新，选择和删除的过程。

i am getting problem with stored procedures, i want to know How to write Stored Procedure in sql server and how to call that in front end and give me simple example like procedure for insert ,update ,select and delete.

推荐答案

我建​​议你先试用MSDN。这里有一些链接



存储过程

http://msdn.microsoft.com/en-us/library/aa214299(v=sql.80).aspx [ ^ ]

CREATE PROCEDURE 语句带示例

http://msdn.microsoft.com/en-us/library/ms187926.aspx [ ^ ]

I suggest you to try MSDN first. Here''s some links

Stored procedures
http://msdn.microsoft.com/en-us/library/aa214299(v=sql.80).aspx[^]
CREATE PROCEDURE statement with examples
http://msdn.microsoft.com/en-us/library/ms187926.aspx[^]

这篇关于如何在sql server中编写存储过程以及如何在前端调用它并给我一个简单的例子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！