SQL Server，table on接受特定时间

Question

我想要为商店的开张和关闭时间创建约束，对于上午9点之后的开店和晚上9点之前的关门，我如何使用时间戳来实现它。谢谢。

IF OBJECT_ID('[toyStoreManagement].[dbo].[TOY_STORE]', 'U') IS NOT NULL
DROP TABLE [toyStoreManagement].[dbo].[TOY_STORE]
GO
-- Create the table in the specified schema
CREATE TABLE [toyStoreManagement].[dbo].[TOY_STORE]
(
    [TOY_STORE_ID] INT NOT NULL IDENTITY(1,1) PRIMARY KEY, -- Primary Key column
    [TOY_STORE_NAME] NVARCHAR(30) NOT NULL,
    [CITY] NVARCHAR(30) NOT NULL,
    [PHONENUMBER] NUMERIC(10) NOT NULL UNIQUE(PHONENUMBER),
    [STORE_OPENING_TIME] TIMESTAMP (***HERE***) ,
    [STORE_CLOSING_TIME] TIMESTAMP (***AND HERE***)
    -- Specify more columns here
);
GO

Answer 1

TIMESTAMP不是你想的那样。您需要具有CHECK约束的TIME列：

STORE_OPENING_TIME TIME,
STORE_CLOSING_TIME TIME,
CHECK (STORE_OPENING_TIME >= '09:00'00' AND STORE_CLOSING_TIME <= '21:00:00')