数据库 存储过程 从数据类型 nvarchar 转换为 smallint 时出错。
消息 8114,级别 16,状态 5,过程 add_patientinfo,第 0 行
从数据类型 nvarchar 转换为 smallint 时出错。
(1 行受影响)
存储过程如下:
USE [MyHostpitalno]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[add_patientinfo]
@mediccareid = N'12',
@inhospital = N'21',
@sickbedid = N'12',
@endscpid = 21,
@endscpcode = 2,
@instrumentid = N'12',
@patientname = N'dsfa',
@sex = N'1',
@birthday = N'1990-11-12',
@age = 21,
@phone = N'123',
@address = N'dsagfsdgasg',
@worksite = N'dsafsd',
@askhospt = 12,
@askdept = 12,
@askdr = 12,
@asktime = N'1990-11-12',
@checkdr = N'dsfa'
SELECT 'Return Value' = @return_value
GO
存储过程用到的表:
PATIENTID int Unchecked
MEDICCAREID varchar(20) Checked
INHOSPITAL varchar(20) Checked
SICKBEDID varchar(10) Checked
ENDSCPID int Unchecked
ENDSCPCODE smallint Unchecked
INSTRUMENTID tinyint Unchecked
PATIENTNAME varchar(10) Unchecked
SEX char(1) Unchecked
BIRTHDAY datetime Checked
AGE smallint Unchecked
PHONE varchar(30) Unchecked
ADDRESS varchar(40) Checked
WORKSITE varchar(40) Checked
ASKHOSPT smallint Checked
ASKDEPT smallint Checked
ASKDR smallint Checked
ASKTIME datetime Checked
CHECKDR smallint Checked
CHECKDEPT smallint Checked
CHECKTIME datetime Checked