Jeff-Lewis / codesmith

Automatically exported from code.google.com/p/codesmith
0 stars 0 forks source link

AllStoredProcedures.cst should not support the TimeStamp datetype #30

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Execute the template against the following schema

/****** Object:  Table [dbo].[ActivityLog]    Script Date: 11/05/2008
13:50:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ActivityLog](
 [RowID] [int] IDENTITY(1,1) NOT NULL,
 [UserGUID] [uniqueidentifier] NOT NULL,
 [ActivityTypeID] [int] NOT NULL,
 [Data] [nvarchar](255) NOT NULL,
 [CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_ActivityLog_CreatedDate]
 DEFAULT (getdate()),
 [UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_ActivityLog_UpdatedDate]
 DEFAULT (getdate()),
 [RowTimestamp] [timestamp] NOT NULL,
 CONSTRAINT [PK_ActivityLog] PRIMARY KEY CLUSTERED
(
 [RowID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

2. Execute generated procedures.

What is the expected output? What do you see instead?
Should not error.

Original issue reported on code.google.com by bniemyjski on 10 Nov 2008 at 3:21

GoogleCodeExporter commented 9 years ago

Original comment by bniemyjski on 28 Jan 2009 at 11:01

GoogleCodeExporter commented 9 years ago

Original comment by bniemyjski on 1 Jul 2009 at 7:18