Fungsi Case pada Data Procedure

---------------------

NAME : SUKRIYADI

NPM   : 2010240333

CLASS : SI4B

STUDY : BASIS DATA TERAPAN

---------------------

create database TBLMahasiswa

use TBLMahasiswa

     

create table TBLMahasiswa

(

NPM varchar(10)primary key,

NAMA varchar(20),

JURUSAN varchar (20)

)

select*from TBLMahasiswa

create proc InputMHS

@a date ,

@b varchar (2)

as

declare

@jumlahbaris integer,

@x varchar (10),

@y integer

select @jumlahbaris=COUNT(*)from TBLMahasiswa

set @y=@jumlahbaris+1

SELECT @x CASE @b from TBLMahasiswa

 WHEN 'SI' Then 24

 WHEN 'TI' THEN 25

 WHEN 'MI' THEN 11

 WHEN 'KA' THEN 13

 WHEN 'TK' THEN 12

set @x= CONVERT (VARCHAR,DATEPART (YEAR ,@a)) + @b +

 CAST (@y as varchar (4))

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

exec InputMHS 'SUKRIYADI','SI'

select*from TBLMahasiswa

SEMOGA BERMANFAAT

---