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