单选题
设在SQL Server 2008某数据库中建有如下会员卡表:
CREATE TABLE
Table_Card (
CardID char(4)
PRIMARY KEY,
StartDate datetime
NOT NULL,
Score int
NOT NULL DEFAULT 0,
State
int NOT NULL CHECK(State
in(0,1,2))
)
现表中无数据,某用户对此表依次进行了如下操作:
Ⅰ.INSERT INTO Table_Card
VALUES('1001','2012-1-1
12:30:01',154,0)
Ⅱ.INSERT INTO
Table_Card(CardID,StartDate,State)
VALUES('1002','2012-1-1
12:30:02',1)
Ⅲ.INSERT INTO Table_Card
VALUES('1003','2012-1-1 12:30:03',172,2)
Ⅳ.INSERT INTO
Table_Card
VALUES('1004','2012-1-1 12:30:04',135,3)
Ⅴ.UPDATE Table_Card SET State=3 WHERE CardID='1001'
Ⅵ.UPDATE Table_Card SET State=1 WHERE CardlD='1004'
以上操作对Table_Card表数据产生影响的是
- A.仅Ⅰ、Ⅱ和Ⅲ
- B.仅Ⅰ、Ⅴ和Ⅵ
- C.仅Ⅰ、Ⅱ、Ⅲ和Ⅵ
- D.仅Ⅲ、Ⅳ、Ⅴ和Ⅵ