[SQL] Stored procedure (2)

Stored procedure (2)

 

Stored procedure 생성

예시 1) 

create proc sp_insertBranch @c1 char(4),
							@c2 varchar(25),
							@c3 varchar(15),
							@c4 varchar(8)
as
begin
insert into dbo.Branch values( @c1, @c2, @c3, @c4 )
end

 

 

 

예시 2)

create proc sp_updateBranch @c1 char(4),
							@c2 varchar(25),
							@c3 varchar(15),
							@c4 varchar(8)
as
begin
update dbo.Branch
	set street=@c2, city = @c3, postcode = @c4
	where branchNo = @c1
end

 

 

 

예시 3)

use DreamHome
go

create proc sp_deleteBranch @c1 char(4)

as
begin
	delete from dbo.branch
			where branchNo = @c1
end

 

 

 

Stored procedure 삭제

예시)

drop procedure sp_insertBranch