倒數第二行在將 varchar 值 'NULL' 轉換成資料型別 tinyint 時失敗。怎么解決啊
USE teaching
GO
CREATE TABLE student
(
sno char(7)PRIMARY KEY,
sname nvarchar(8)NOT NULL,
ssex nchar(1)NOT NULL CONSTRAINT chk_sex CHECK(ssex='男'or ssex='女'),
sage varchar(2) NULL CONSTRAINT chk_age CHECK(sage between 15 AND 30),
en_time datetime NULL,
specialty varchar(20)NULL,
grade char(10)NULL
)
INSERT into student VALUES('1302001','張明明','男','20','2013-09-06','計算機','13級')
INSERT into student VALUES('1302005','鄭麗','女','21','2013-09-06','網路','13級');
INSERT into student VALUES('1401001','朱一虹','女','19','2014-09-09','計算機','14級')
INSERT into student VALUES('1401003','沈艷','女','20','2014-09-05','電子','14級');
INSERT into student VALUES('1403001','趙麗紅','女','20','2013-09-06','網路','14級')
INSERT into student VALUES('1404001','李宏偉','男','19','2013-09-06','通信','14級')
INSERT into student VALUES('1404006','劉景鵬','男','19','2013-09-06','通信','14級')
INSERT into student VALUES('1501001','張玲','女','19','2013-09-06','電子','15級')
INSERT into student VALUES('1501008','張玲','女','18','2013-09-06','電子','15級')
INSERT into student VALUES('1502003','張強','男','19','2013-09-06','電子','15級')
INSERT into student VALUES('1502005','劉梅','女','19','2013-09-06','計算機','15級')
INSERT into student VALUES('1503001','張強','男','18','2013-09-06','網路','15級')
USE teaching
GO
CREATE TABLE course
(
cno char(4)PRIMARY KEY,
cname nvarchar(20)NOT NULL,
classhour tinyint,
credit tinyint
)
INSERT into course VALUES('C001','c++語言','3','4')
INSERT into course VALUES('C004','作業系統','3','3')
INSERT into course VALUES('E002','電子技術','5','5')
INSERT into course VALUES('R005','軟體工程','3','3')
INSERT into course VALUES('X003','信號原理','4','3')
USE teaching
GO
CREATE TABLE sc
(
sno char(7)NOT NULL,
cno char(4)NOT NULL,
score tinyint null CONSTRAINT chk_score CHECK(score between 0 AND 100),
PRIMARY KEY(sno,cno),
FOREIGN KEY(sno)REFERENCES student(sno),
FOREIGN KEY(cno)REFERENCES course(cno)
)
INSERT into sc VALUES('1302001','C001','100')
INSERT into sc VALUES('1302001','C004','81')
INSERT into sc VALUES('1302001','X003','85')
INSERT into sc VALUES('1302005','C001','78')
INSERT into sc VALUES('1302005','C004','97')
INSERT into sc VALUES('1401003','C001','72')
INSERT into sc VALUES('1401003','E002','73')
INSERT into sc VALUES('1403001','C001','85')
INSERT into sc VALUES('1404001','E002','76')
INSERT into sc VALUES('1501001','X003','NULL')
INSERT into sc VALUES('1501008','X003','NULL')
uj5u.com熱心網友回復：
不要引號INSERT into sc VALUES('1501008','X003',NULL)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/46257.html
標籤：基礎類
上一篇：我用的是sts和mysql一起運行一個代碼，報錯500
下一篇：以前用sql server2005可以運行，由于一些原因現在用sql server 2008 R2，但是提示用戶名密碼錯誤，求大佬指導