study

저장 프로시져

intseq 2010. 12. 26. 18:58

USE [ClickDB]
GO
/****** Object:  StoredProcedure [dbo].[sp_AddMember]    Script Date: 12/26/2010 18:59:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[sp_AddMember]
@userid varchar(20),
@password varchar(20),
@name varchar(20),
@email varchar(20)

as
insert into Member
(userid, password, name, email)
values
(@userid, @password,@name,@email)

return