最简单的SQL存储过程调用（不会存储过程的人非常值得看，很有实际意义）

存储过程的概念性的东西我就不说了，因为搜索引擎的东西比我更详细与精彩。我只举例来做更实际的东西。

首先是创建一个数据库sample然后用下面的语句创建一个表，当然表里的数据你最好是插入一些，不想的话也可以。先调用增的存储过程，再调用删、改、查的存储过程。

USE [sample] /****** sample这个数据库自己创建 *****************/ GO /****** 对象: Table [dbo].[test] 脚本日期: 03/11/2010 10:36:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[test]( [id] [int] NULL, [name] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]

也许需要说一点的是，存储过程是放在数据库里的，这跟触发器是一样的。只需要把下面的语句放在数据库里执行就可以了

-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE proc_insert -- Add the parameters for the stored procedure here ( @temp_id int， @temp_name nvarchar(50) ) BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here insert into dbo.test (id,name) values(@temp_id,@temp_name) END GO exec proc_test 'test',2 --这里需要注意的是关键这as不能少 --有了begin就不能没有end --第一次创建存储过程用create，第二次及以后则需要把create改成alter --也就是编辑存储过程 --exec后面的参数要是不想写完整，则需要跟存储过程的参数次序对应

-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE proc_delete -- Add the parameters for the stored procedure here @temp_id int as BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here delete from test where id=@temp_id END GO exec proc_delete 1 --as关键字不能少 --有begin不能少end --exec进行调用 --第一次创建存储过程用create，第二次及以后则需要把create改成alter --也就是编辑存储过程 --exec后面的参数要是不想写完整，则需要跟存储过程的参数次序对应

-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE proc_update -- Add the parameters for the stored procedure here @temp_id int as BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here update test set name='jack' where id=@temp_id END GO exec proc_update 2 --as关键字不能少 --有begin不能少end --exec进行调用 --第一次创建存储过程用create，第二次及以后则需要把create改成alter --也就是编辑存储过程 --exec后面的参数要是不想写完整，则需要跟存储过程的参数次序对应

-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= create PROCEDURE proc_select -- Add the parameters for the stored procedure here as BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here select * from test END GO exec proc_select --as关键字不能少 --有begin不能少end --exec进行调用 --第一次创建存储过程用create，第二次及以后则需要把create改成alter --也就是编辑存储过程

上面我都把要点写在代码里面了，在每个代码的最后注释说明就是其中的重点

这是一个过渡性的学习，希望能带给你柳开花明又一村的感觉。