SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

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

CREATE VIEW dbo.[DeluxeCD Tracks]
AS
SELECT TitleID, TrackID + 1 AS TrackID, 
        { fn SUBSTRING({ fn CONVERT(TrackName, SQL_CHAR) }, 1, 1000) } AS TrackName
FROM  DELUXECD...Tracks



GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

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