Contoh Stored Procedure

Untuk insert :

create procedure sp_tambahmhspwt3
@vnim nchar(10),@vnama nvarchar(40),@vkota nvarchar(20)
as
if @vkota='purwokerto'
  insert into tbmahasiswa values(@vnim,@vnama,@vkota)
  
exec sp_tambahmhspwt '11.10.0055','Titis s','purwokerto'
exec sp_liatdatamhs

Untuk hapus :
create procedure sp_hapusmhs3
@vnim nchar(10)
as
if left(@vnim,2)<>'11'
  begin
  delete from detail_matkul where nim=@vnim
  delete from tbmahasiswa where nim=@vnim
  end
exec sp_hapusmhs '11.10.0055'