SQLize Online / PHPize Online  /  SQLtest Online

CREATE PROCEDURE Kpop @chvFullname varchar (200) as BEGIN select Fullname, Appointment, Seating_chart, Country, Payment from girl_groups where Fullname = @chvFullname END create a procedure from the table girlgroups name it Kpop with a parameter of (250) set the parameter of @chvFullname to (200) begin the procedure select the Appointment, Seating_chart, Country, Payment column from girlgroups where Fullname is equal to @chvFullnamea end the procedure create table girl_groups ( order_id int identity(1,1) not null, Seatnumber INT, Fullname VARCHAR(150), Kpop_Group VARCHAR(150), Appointment VARCHAR(150), Seating_chart VARCHAR(150), Country VARCHAR(150), Payment decimal(10,2), ); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('20', 'Luna Valeria', 'Red Velvet', '4/12/2012', 'General Admission','Philippines', '5000.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('19', 'Akihiro Juarez', 'ITZY','3/14/2016', 'Upperbox', 'Hong Kong', '50000.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('41', 'Shan Lopez', 'ITZY', '3/14/2016', 'Upperbox', 'Philippines', '50000.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('89', 'Elyse Ledezma', 'Twice','7/7/2016', 'Diamond','Philippines', '75000.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('81', 'Via Diaz', 'Red Velvet', '4/12/2012', 'Upperbox', 'Spain', '50000.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('95', 'Yanna Fernandez', 'Blackpink', '9/10/2016', 'Diamond','Philippines', '75000.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('94', 'Sam Vera', 'Blackpink', '9/10/2016','Diamond','Paris', '7500.00'); insert into girl_groups (Seatnumber, Fullname, Kpop_Group, Appointment, Seating_chart, Country, Payment) values ('98', 'Larkin Sanchez', 'Red Velvet', '4/12/2012', 'Diamond', 'Paris', '75000.00'); select * from girl_groups