SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.UC_DELUXECD_DATABASE
Script Date: 1/23/2000 1:11:45 PM ******/
if exists (select * from sysobjects
where id = object_id(N'[dbo].[UC_DELUXECD_DATABASE]') and
OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UC_DELUXECD_DATABASE]
GO
CREATE PROCEDURE UC_DELUXECD_DATABASE
AS
SELECT *
FROM [DeluxeCD Titles] INNER JOIN
[DeluxeCD Tracks] ON
[DeluxeCD Titles].TitleID = [DeluxeCD Tracks].TitleID
ORDER BY [DeluxeCD Titles].[Artist], [DeluxeCD Titles].[ReleaseDate],
[DeluxeCD Titles].[Title], [DeluxeCD Tracks].[TrackID]
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO
This page was last updated on May 01, 2006 04:28 PM.