Program DataBase SQL 2

create database P8

use P8

create table login
(
Username varchar(20),
Password varchar(20),
constraint pklogin primary key (Username)
)

insert into login values('2011240105','MDP')
insert into login values('2011240169','MDP123')

select *from login

select *from login where Username ='2011240105' and Password ='MDP'

====================================================================
(SQL Injection)
select *from login where Username ='2011240105'--'
select *from login where Username =''or''=''



(Menampilkan Tabel Login)
create proc PSelectLogin
as
select *from login

exec PSelectLogin

alter proc PSelectLogin
@x varchar(20),
@y varchar (20)
as
select *from login where Username =@x and Password =@y

exec PSelectLogin '2011240169','MDP123'

====================================================================create proc PTambahMember
@a varchar(20),
@b varchar(20)
as
insert into login values(@a,@b)

exec PTambahMember '2011240167','123'


select *from login

====================================================================
PERBARUI DATA

create proc PUbahPassword
@a varchar(20),
@b varchar(20)
as
update login set Password =@a where Username = @b

exec PUbahPassword  '5566','2011240167'