将 varchar 值 '*' 转换为数据类型为 int 的列时发生语法错误。
createtablesc(snochar(9),cnochar(4),gradesmallint,primarykey(sno,cno))insertintosc(sn...
create table sc
(sno char(9),
cno char(4),
grade smallint,
primary key(sno,cno)
)
insert
into sc(sno,cno,grade)
values('95001','1','92')
insert
into sc(sno,cno,grade)
values('95001','2','85')
insert
into sc(sno,cno,grade)
values('95001','3','88')
insert
into sc(sno,cno,grade)
values('95002','2','90')
insert
into sc(sno,cno,grade)
values('95002','3','80')
select *from sc
建存储过程
CREATE PROCEDURE PRO_1
AS
update sc
set grade='A'
where grade>90 and grade<=100
update sc
set grade='B'
where grade>80 and grade<=90
update sc
set grade='C'
where grade>70 and grade<=80
update sc
set grade='D'
where grade>=60 and grade<=70
update sc
set grade='E'
where grade<60
运行时发生错误 --将 varchar 值 '*' 转换为数据类型为 int 的列时发生语法错误。 展开
(sno char(9),
cno char(4),
grade smallint,
primary key(sno,cno)
)
insert
into sc(sno,cno,grade)
values('95001','1','92')
insert
into sc(sno,cno,grade)
values('95001','2','85')
insert
into sc(sno,cno,grade)
values('95001','3','88')
insert
into sc(sno,cno,grade)
values('95002','2','90')
insert
into sc(sno,cno,grade)
values('95002','3','80')
select *from sc
建存储过程
CREATE PROCEDURE PRO_1
AS
update sc
set grade='A'
where grade>90 and grade<=100
update sc
set grade='B'
where grade>80 and grade<=90
update sc
set grade='C'
where grade>70 and grade<=80
update sc
set grade='D'
where grade>=60 and grade<=70
update sc
set grade='E'
where grade<60
运行时发生错误 --将 varchar 值 '*' 转换为数据类型为 int 的列时发生语法错误。 展开
2个回答
展开全部
create table sc
(sno char(9),
cno char(4),
grade smallint,
primary key(sno,cno)
)
go
insert
into sc(sno,cno,grade)
values('95001','1','92')
insert
into sc(sno,cno,grade)
values('95001','2','85')
insert
into sc(sno,cno,grade)
values('95001','3','88')
insert
into sc(sno,cno,grade)
values('95002','2','90')
insert
into sc(sno,cno,grade)
values('95002','3','80')
go
select *from sc
--建存储过程
CREATE PROCEDURE PRO_1
AS
update sc
set grade='A'
where grade>90 and grade<=100
update sc
set grade='B'
where grade>80 and grade<=90
update sc
set grade='C'
where grade>70 and grade<=80
update sc
set grade='D'
where grade>=60 and grade<=70
update sc
set grade='E'
where grade<60
go
exec PRO_1
go
(sno char(9),
cno char(4),
grade smallint,
primary key(sno,cno)
)
go
insert
into sc(sno,cno,grade)
values('95001','1','92')
insert
into sc(sno,cno,grade)
values('95001','2','85')
insert
into sc(sno,cno,grade)
values('95001','3','88')
insert
into sc(sno,cno,grade)
values('95002','2','90')
insert
into sc(sno,cno,grade)
values('95002','3','80')
go
select *from sc
--建存储过程
CREATE PROCEDURE PRO_1
AS
update sc
set grade='A'
where grade>90 and grade<=100
update sc
set grade='B'
where grade>80 and grade<=90
update sc
set grade='C'
where grade>70 and grade<=80
update sc
set grade='D'
where grade>=60 and grade<=70
update sc
set grade='E'
where grade<60
go
exec PRO_1
go
追问
和我写的有区别吗?
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询