DB 쿼리1

-- DB:200801417
-- Drop table Member

Create Table Member
(
  [num] [int] IDENTITY (1,1) Primary Key ,
  [userid] [varchar] (20) NOT NULL ,
  [password] [varchar] (20) NOT NULL ,
  [name] [varchar] (20) NOT NULL ,
  [email] [varchar] (20) NOT NULL ,
  [joindate] SmallDateTime Default (GetDate())
)
GO

Insert Member (userid, password, name, email)
 Values ('kbs', '1111', '캐백수', 'kbs@yahoo.com')
 
Insert Member (userid, password, name, email)
 Values ('mbc', '1111', '마봉춘', 'mbc@yahoo.com')
 
Insert Member (userid, password, name, email)
 Values ('sbs', '1111', '스브스', 'sbs@yahoo.com')
 
Select * From Member
Order By num Desc

Select * From Member
Where Num = 2

Update Member
Set 
 Name = '에스브스',
 Email = 'ssbbss@b.com'
Where
 Name = 10
 And
 Password = '1111'

Delete Member Where
 Num = 9 And password = '1111'
 
Select * From Member
Where Name Like '%스%'
Go

-- 저장하기 프로시저생성
CREATE PROCEDURE dbo.sp_AddMember
(
       @userid varchar(20),
       @password varchar(50),
       @name varchar(20),
       @email varchar(20),
       @joindate SmallDateTime
)
AS
     INSERT into Member (userid, password, name, email, joindate) 
     VALUES (@userid,@password,@name,@email,@joindate) 
GO


-- DROP PROCEDURE sp_AddMember  -- 프로시저삭제

-- DROP PROCEDURE sp_GetMember   -- 프로시저삭제

--[13] 읽어오기 저장프로시저
Create Proc sp_GetMember
AS
 Select *  From  Member
 Order By num Desc
Go