希望大家帮我解决一下sql问题
create procedure staff_proc
(
@staffNumber char(20),
@staffName char(20),
@staffSalary money,
@staffTime int,
@departmentNumber char(20),
@departmentName char(20)
)
as
insert into staff values(@staffNumber,@staffName,@staffSalary,@staffTime,@departmentNumber,@departmentName)
update department
set departmentCount=departmentCount+1
where departmentNumber=@departmentNumber
exec staff_proc '1121811','张三',3000,25,'101','人事部'
将 varchar 值 '人事部 ' 转换为数据类型为 int 的列时发生语法错误。
不知道怎么错了
[解决办法]
insert into staff(列名补充对应)
values(@staffNumber,@staffName,@staffSalary,@staffTime,@departmentNumber,@departmentName)
[解决办法]
staff表的数据类型错误
insert into staff
(列名对应)
values(@staffNumber,@staffName,@staffSalary,@staffTime,@departmentNumber,@departmentName)