Below is code from my original db in MS SQL 7 followed by how it ported to MS SQL 2000. Should i match the code to the sql 7 or is those collate statements ok?
========================================================= SQL Server 7 ========================================================= -- Columns CREATE TABLE [cb8m].[Event] ( [EventID] [int] NOT NULL IDENTITY(1, 1), [EventTypeID] [int] NOT NULL, [EventName] [varchar] (150) NULL, [ContactName] [varchar] (150) NULL, [ContactEmail] [varchar] (150) NULL, [ContactPhone] [varchar] (25) NULL, [EventShortDesc] [varchar] (250) NULL, [EventDescription] [text] NULL, [Location] [varchar] (200) NULL, [EventURL] [varchar] (250) NULL, [StartDateTime] [datetime] NULL, [EndDateTime] [datetime] NULL, [AllDayFlag] [int] NULL, [EventImage] [varchar] (100) NULL ) GO -- Constraints and indexes ALTER TABLE [cb8m].[Event] ADD CONSTRAINT [PK__Event__4CA06362] PRIMARY KEY CLUSTERED ([EventID]) GO -- Foreign keys ALTER TABLE [cb8m].[Event] ADD CONSTRAINT [FK__Event__EventType__4F7CD00D] FOREIGN KEY ([EventTypeID]) REFERENCES [cb8m].[EventType_Ref] ([EventTypeID]) GO =========================================================== SQL Server 2000 =========================================================== -- Columns CREATE TABLE [cb8m].[Event] ( [EventID] [int] NOT NULL IDENTITY(1, 1), [EventTypeID] [int] NOT NULL, [EventName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ContactName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ContactEmail] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ContactPhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EventShortDesc] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EventDescription] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Location] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EventURL] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [StartDateTime] [datetime] NULL, [EndDateTime] [datetime] NULL, [AllDayFlag] [int] NULL, [EventImage] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) GO -- Constraints and indexes ALTER TABLE [cb8m].[Event] ADD CONSTRAINT [PK__Event__4CA06362] PRIMARY KEY CLUSTERED ([EventID]) GO -- Foreign keys ALTER TABLE [cb8m].[Event] ADD CONSTRAINT [FK__Event__EventType__4F7CD00D] FOREIGN KEY ([EventTypeID]) REFERENCES [cb8m].[EventType_Ref] ([EventTypeID]) GO ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233437 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
