写过一篇存储过程入门的博客,那仅仅是入门,下面和大家一起深入学习存储过程(也许以后还会有更深入^_^)
以经典的注册为例子,篇幅有限只写了核心部分,其他略过。
无参数无返回值的存储过程以默认的信息进行注册
其中存储过程代码如下
1: USE [Test]2: GO3: /****** Object: StoredProcedure [dbo].[MyProcedure1] Script Date: 04/04/2011 20:55:13 ******/4: SET ANSI_NULLS ON5: GO6: SET QUOTED_IDENTIFIER ON7: GO8: ALTER proc [dbo].[MyProcedure1]9: as10: begin11: insert into Login values ('admin','admin')12: end程序代码如下
1: Dim Str As String = "Data Source=******;Initial Catalog=Test;User ID=sa;Password=*****"2: Dim conn As SqlConnection = New SqlConnection(Str)3: Private Sub btnNoParNoOut_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNoParNoOut.Click4: Dim sql As String = "execute MyProcedure1"5: Dim cmd As SqlCommand = New SqlCommand(sql, conn)