INFO 340 Study Guide - Quiz Guide: Stored Procedure
INFO 340 Quiz6 Review Code
--STORED PROCEDURE
/*
Insert new row into ALBUM
*/
CREATE PROCEDURE uspNewAlbum
@A_Name varchar(30),
@Label varchar(60),
@R_Date Date
AS
DECLARE @Lab_ID INT
SET @Lab_ID = (
SELECT LabelID
FROM LABEL
WHERE LabelName = @Label
)
BEGIN TRAN G1
INSERT INTO ALBUM (AbumName, LabelID, ReleaseDate)
VALUES (@A_Name, @Lab_ID, @R_Date)
IF @@ERROR <> 0
ROLLBACK TRAN G1
ELSE
COMMIT TRAN G1
/*
Insert new row into ARTIST_RECORDING
*/
CREATE PROCEDURE uspNewArtistRecording
@A_Fname varchar(30),
@A_Lname varchar(30),
@R_name varchar(100),
@I_name varchar(100)
AS
DECLARE @I_ID INT
DECLARE @A_ID INT
DECLARE @R_ID INT
SET @I_ID = (
SELECT InstrumentID
FROM INSTRUMENT
WHERE InstrumentName = @I_Name
)