Good Morning!
Please forgive my english.
I have an issue that I don't understand why or what's wrong.
I'm using Sql Server Express 2014 x 64 12.0.2000.8
I create the next table and insert one row:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [nom].[foo]
(
[id] [int] IDENTITY(1, 1) NOT NULL,
[begin] [date] NOT NULL,
[end] [date] NOT NULL,
CONSTRAINT [PK_foo] PRIMARY KEY CLUSTERED
(
[id] ASC
)
WITH
(
PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
) ON [PRIMARY],
) ON [PRIMARY]
GO
ALTER TABLE [nom].[foo] WITH CHECK ADD CONSTRAINT [CK_foo_begin] CHECK (([end]>=[begin]))
GO
ALTER TABLE [nom].[foo] CHECK CONSTRAINT [CK_foo_begin]
GO
INSERT INTO [nom].[foo]
(
[begin],
[end]
)
VALUES
(
'1/1/1014',
'2/1/2014'
)
GO
Here every thing is O ...
Go to the complete details ...