Chinook
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ResultSetProcedure
Parameters
Name
Type
Mode
Definition
-- ============================================= -- Author: This is Author -- Create date: 06-08-2017 -- Description: Simple Procedure -- ============================================= CREATE PROCEDURE ResultSetProcedure AS BEGIN SET NOCOUNT ON; SELECT "Album"."Title" AS album, "Artist"."Name" AS artist FROM "Album", "Artist" WHERE ("Artist"."ArtistId" = "Album"."ArtistId"); END