cara membuat stored procedure dan function
create database basisdata
use basisdata
create table tb_mhs (nim int,nama char (20))
insert into tb_mhs (nim,nama) values ('1418123','firman')
insert into tb_mhs (nim,nama) values ('1418162','arka')
use basisdata
create table tb_mhs (nim int,nama char (20))
insert into tb_mhs (nim,nama) values ('1418123','firman')
insert into tb_mhs (nim,nama) values ('1418162','arka')
Stored Procedure
create proc sp_mhs (@nim int,@nama char (20))
as
begin
insert into tb_mhs values (@nim,@nama)
end
exec sp_mhs '1418082','madhar'
select *from tb_mhs
Function
create function jumlah_mhs()
returns int
as
begin
declare @hasil int;
select @hasil = count (nim) from tb_mhs;
return @hasil
end
select dbo.jumlah_mhs() as jumlah_mahasiswa
Tidak ada komentar:
Posting Komentar