SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object: View dbo.DeluxeCD Titles Script Date: 1/23/2000 1:11:06 PM ******/
if exists (select * from sysobjects
                where id = object_id(N'[dbo].[DeluxeCD Titles]') and
                        OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[DeluxeCD Titles]
GO

CREATE VIEW dbo.[DeluxeCD Titles]
AS
SELECT TitleID,
        { fn SUBSTRING({ fn CONVERT(Artist, SQL_CHAR) }, 1, 1000) } AS Artist,
        { fn SUBSTRING({ fn CONVERT(Title, SQL_CHAR) }, 1, 1000) } AS Title,
        { fn SUBSTRING({ fn CONVERT(Copyright, SQL_CHAR) }, 1, 1000) } AS Copyright,
        { fn SUBSTRING({ fn CONVERT(Label, SQL_CHAR) }, 1, 1000) } AS Label,
        { fn SUBSTRING({ fn CONVERT(ReleaseDate, SQL_CHAR) }, 1, 1000) } AS ReleaseDate,
        NumTracks
FROM  DELUXECD...Titles



GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

This page was last updated on May 01, 2006 04:28 PM.