Given the database table below, write a stored procedure called SP GetBCStationI

Question

Given the database table below, write a stored procedure called SP GetBCStationInfo. This stored procedure will accept a single argument that represents the format field. The stored procedure will get all information from the table below based on this parameter and order the data by 'city'. You will create this stored procedure in a text file that can be run using the MySQL 'source' command. Database Name: hreadcast_info Table Name: fn_stations Write the stored Procedure below: Shown an example how this stored procedure would be called using the MySQL command line interface:

Explanation / Answer

Create proceudre fn_stations(

@callsign varchar(4),

@stations varchar(15),

@city varchar(15),

@format varchar(15)

As Begin

Insert into fn_stations(

call_sign,station,city,format)values (@callsign,@stations,@city,@format)

End

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.