Table Login & Store Proc

create database Pertemuan8

use Pertemuan8

create table TblKategori

(

KodeKategori varchar (10) primary key,

NamaKategori varchar (100) not null,

Potongan integer

)

create table TblProduk

(

KodeProduk varchar (10) primary key,

KodeKategori varchar (10) not null,

Nama varchar (100) not null,

Harga integer not null,

Stok integer not null,

constraint TblProduk_TblKategori_FK foreign key (KodeKategori)

references TblKategori(KodeKategori)

)

create proc SPinput

@a varchar (10),

@b varchar (100),

@c integer

as

insert into TblKategori values (@a,@b,@c)

exec SPinput 'KK4','Notebook',2000000

exec SPinput 'KK5','Smart Phone',1000000

exec SPinput 'KK6','Desktop',1000000

create proc SPinputproduk

@a varchar (3),

@b varchar (3),

@c varchar (100),

@d integer,

@e integer

as

insert into TblProduk values (@a,@b,@c,@d,@e)

exec SPInputProduk 'KP7','KK4','Hp Pavilion',7000000,12

select *from TblProduk

select *from TblKategori

buat store procedure penambahan kategori

dimana kode kategori didapat dari jumlah baris kategori berikutnya

alter proc InputKategori1

@a varchar (100),

@b integer

as

declare

@jumlahbaris integer,

@x varchar (10),

@y integer

select @jumlahbaris=COUNT(*)from TblKategori

set @y=@jumlahbaris+1

set @x= 'KK' + CAST (@y as varchar (8))

insert into TblKategori values(@x,@a,@b)

exec InputKategori1 'LCD',157000

exec InputKategori1 'Printer',17000

exec InputKategori1 'Printer2',127000

select*from TblKategori

_______________________________________________________________________

create table login

(username varchar (10) primary key,

password varchar (10) not null)

insert into login values ('user1','pass1')

insert into login values ('user2','pass2')

select *from login where username = 'user1' and password = 'pass1'

bisa di tembus tanpa pasword

select *from login where username = 'user1' --and password = 'pass1'

bisa di tembus tanpa username & facebook

select *from login where username =''or''='' and password =''or''=''

store procedure

create proc SPlogin

@x varchar (10),

@y varchar (10)

as

select *from login where username = @x and password = @y

exec SPlogin 'user1','pass1'

SEMOGA BERMANFAAT

---