INSERT
INTO
IPatient ( UID, PatientNo, PatientName, PatientGender, Birthday, BloodType, Country, Nation, Nativeplace, Tel, Addr, Zipcode, PtType, FeeType, Ssn, Pno, Area, HosNo, BedNo, CurDept, CurDoctor, Diag, Remark, Checker, CResult, Animal, LabNo, Pid, FirstName, MidName, Age, AgeUnit, IsPrimary )
VALUES
( 13,
'BR13'
,
'狐狸涛'
, 1,
'1989-02-03'
, 2, N
'ZH'
, N
'VVVVV'
, N
'SZ'
,
'13861677197'
, N
'阿的发放'
,
'215153'
, 1, 2,
'112233'
,
'pnos'
,
'重症监护室'
, 12,
'bed001'
,
'治疗科室'
,
'主治医生'
,
'临床诊断'
,
'备注aaa'
,
'审核张'
,
'审核结果...'
, 1,
'实验室编号'
,
'仪器编号'
,
''
,
''
, 18,
'Year'
, 1 )
|
测试数据
结果插入后显示乱码
这从没遇到过啊
分析可能是sql排序问题,当前排序规则是SQL_Latin1_General_CP1_CI_AS
结果修改失败
只能用命令修改了
ALTER
DATABASE
databaseName
SET
SINGLE_USER
WITH
ROLLBACK
IMMEDIATE
Go
ALTER
DATABASE
databaseName
COLLATE
Chinese_PRC_CI_AS
Go
ALTER
DATABASE
databaseName
SET
MULTI_USER
Go
|
如果执行失败多次执行或者单步执行试试
重新插入,已经成功.