存储过程进阶（vb.net+SQL Server2008环境）

写过一篇存储过程入门的博客，那仅仅是入门，下面和大家一起深入学习存储过程（也许以后还会有更深入^_^）

以经典的注册为例子，篇幅有限只写了核心部分，其他略过。

 

• 无参数无返回值的存储过程

以默认的信息进行注册

其中存储过程代码如下

   1:  USE [Test]

   2:  GO

   3:  /****** Object:  StoredProcedure [dbo].[MyProcedure1]    Script Date: 04/04/2011 20:55:13 ******/

   4:  SET ANSI_NULLS ON

   5:  GO

   6:  SET QUOTED_IDENTIFIER ON

   7:  GO

   8:  ALTER proc [dbo].[MyProcedure1]

   9:  as 

  10:  begin

  11:  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.Click

   4:          Dim sql As String = "execute MyProcedure1"

   5:          Dim cmd As SqlCommand = New SqlCommand(sql, conn)