CREATE TABLE tb ( ID INT IDENTITY NOT NULL, StartDateTime DATETIME, CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime < GETDATE()) );
create table a ( a int, dates datetime check(dates>getdate()) )
加个约束,CHECK(COL,StartDateTime >=GETDATE())
create table a ( a int, dates datetime check(dates<getdate()) ) 汗 写反了
也跟着反了,晕晕 CHECK(COL,StartDateTime <=GETDATE())
StartDateTime<=GETDATE()
加个约束S_date datetime check(S_date<getdate())
alter table tableName alter columns StartDateTime dtime CHECK(StartDateTime < GETDATE()
alter table tableName alter columns StartDateTime datetime CHECK(StartDateTime < GETDATE()
CREATE TABLE tb ( ID INT IDENTITY NOT NULL, StartDateTime DATETIME, CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime <= GETDATE()) );
USE TEMPDB GO CREATE TABLE TB ( ID INT IDENTITY(1,1) NOT NULL, DATE DATETIME, CONSTRAINT CK_TB_DATE CHECK(DATE <= CONVERT(VARCHAR(10),GETDATE(),120) ); GO
CREATE TABLE tb ( ID INT IDENTITY NOT NULL, StartDateTime DATETIME, CONSTRAINT CHK_CONS_STARTDATETIME CHECK(datediff(day, StartDateTime, GETDATE())>=0) );
(
ID INT IDENTITY NOT NULL,
StartDateTime DATETIME,
CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime < GETDATE())
);
a int,
dates datetime check(dates>getdate())
)
a int,
dates datetime check(dates<getdate())
)
汗 写反了
CHECK(COL,StartDateTime <=GETDATE())
alter table tableName
alter columns StartDateTime dtime CHECK(StartDateTime < GETDATE()
alter table tableName
alter columns StartDateTime datetime CHECK(StartDateTime < GETDATE()
(
ID INT IDENTITY NOT NULL,
StartDateTime DATETIME,
CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime <= GETDATE())
);
USE TEMPDB
GO
CREATE TABLE TB
(
ID INT IDENTITY(1,1) NOT NULL,
DATE DATETIME,
CONSTRAINT CK_TB_DATE CHECK(DATE <= CONVERT(VARCHAR(10),GETDATE(),120)
);
GO
(
ID INT IDENTITY NOT NULL,
StartDateTime DATETIME,
CONSTRAINT CHK_CONS_STARTDATETIME CHECK(datediff(day, StartDateTime, GETDATE())>=0)
);
SQL太差了,得好好补补.