前几天调了一下数据库的内容,现在保存不了了,不知道怎么回事,EMPID是INT自增,程序保存时跟踪如下:
为什么EMPID=-4,有点不解.
exec sp_executesql N'Insert Into Rs_BasicInfo (EmpNo,EmpName,Birthday,Gender,Nation,IdentityNo,Marrige,DeptCode,DeptName,WorkType,Position,Knowledge,GraduateTime,SchoolName,SpecialtyName,HireProp,EmpSort,HireTime,InductionTime,DimissionTime,InsuNo,PmAccounts,PmLastYAvgSalary,Business,Grade,ImpactGrade,YNStop,Pcdyn,Pic,Pic2,Re,Address,TEL,TEL2) Values (@EmpID,@EmpNo,@EmpName,@Birthday,@Gender,@Nation,@IdentityNo,@Marrige,@DeptCode,@DeptName,@WorkType,@Position,@Knowledge,@GraduateTime,@SchoolName,@SpecialtyName,@HireProp,@EmpSort,@HireTime,@InductionTime,@DimissionTime,@InsuNo,@PmAccounts,@PmLastYAvgSalary,@Business,@Grade,@ImpactGrade,@YNStop,@Pcdyn,@Pic,@Pic2,@Re,@Address,@TEL,@TEL2)', N'@EmpID int,@EmpNo varchar(30),@EmpName varchar(10),@Birthday datetime,@Gender nvarchar(60),@Nation nvarchar(60),@IdentityNo varchar(20),@Marrige nvarchar(60),@DeptCode varchar(12),@DeptName nvarchar(40),@WorkType nvarchar(60),@Position nvarchar(60),@Knowledge nvarchar(60),@GraduateTime datetime,@SchoolName nvarchar(60),@SpecialtyName nvarchar(60),@HireProp nvarchar(60),@EmpSort nvarchar(60),@HireTime datetime,@InductionTime datetime,@DimissionTime datetime,@InsuNo nvarchar(60),@PmAccounts nvarchar(60),@PmLastYAvgSalary nvarchar(60),@Business varchar(20),@Grade varchar(20),@ImpactGrade int,@YNStop bit,@Pcdyn bit,@Pic image,@Pic2 image,@Re nvarchar(60),@Address varchar(200),@TEL varchar(20),@TEL2 varchar(20)', @EmpID = -4, @EmpNo = '1149', @EmpName = 'TEST', @Birthday = NULL, @Gender = N'男', @Nation = NULL, @IdentityNo = NULL, @Marrige = NULL, @DeptCode = '001', @DeptName = N'001', @WorkType = NULL, @Position = NULL, @Knowledge = NULL, @GraduateTime = NULL, @SchoolName = NULL, @SpecialtyName = NULL, @HireProp = NULL, @EmpSort = NULL, @HireTime = NULL, @InductionTime = NULL, @DimissionTime = NULL, @InsuNo = NULL, @PmAccounts = NULL, @PmLastYAvgSalary = NULL, @Business = '新员工', @Grade = NULL, @ImpactGrade = NULL, @YNStop = 0, @Pcdyn = NULL, @Pic = NULL, @Pic2 = NULL, @Re = NULL, @Address = NULL, @TEL = NULL, @TEL2 = NULL
为什么EMPID=-4,有点不解.
exec sp_executesql N'Insert Into Rs_BasicInfo (EmpNo,EmpName,Birthday,Gender,Nation,IdentityNo,Marrige,DeptCode,DeptName,WorkType,Position,Knowledge,GraduateTime,SchoolName,SpecialtyName,HireProp,EmpSort,HireTime,InductionTime,DimissionTime,InsuNo,PmAccounts,PmLastYAvgSalary,Business,Grade,ImpactGrade,YNStop,Pcdyn,Pic,Pic2,Re,Address,TEL,TEL2) Values (@EmpID,@EmpNo,@EmpName,@Birthday,@Gender,@Nation,@IdentityNo,@Marrige,@DeptCode,@DeptName,@WorkType,@Position,@Knowledge,@GraduateTime,@SchoolName,@SpecialtyName,@HireProp,@EmpSort,@HireTime,@InductionTime,@DimissionTime,@InsuNo,@PmAccounts,@PmLastYAvgSalary,@Business,@Grade,@ImpactGrade,@YNStop,@Pcdyn,@Pic,@Pic2,@Re,@Address,@TEL,@TEL2)', N'@EmpID int,@EmpNo varchar(30),@EmpName varchar(10),@Birthday datetime,@Gender nvarchar(60),@Nation nvarchar(60),@IdentityNo varchar(20),@Marrige nvarchar(60),@DeptCode varchar(12),@DeptName nvarchar(40),@WorkType nvarchar(60),@Position nvarchar(60),@Knowledge nvarchar(60),@GraduateTime datetime,@SchoolName nvarchar(60),@SpecialtyName nvarchar(60),@HireProp nvarchar(60),@EmpSort nvarchar(60),@HireTime datetime,@InductionTime datetime,@DimissionTime datetime,@InsuNo nvarchar(60),@PmAccounts nvarchar(60),@PmLastYAvgSalary nvarchar(60),@Business varchar(20),@Grade varchar(20),@ImpactGrade int,@YNStop bit,@Pcdyn bit,@Pic image,@Pic2 image,@Re nvarchar(60),@Address varchar(200),@TEL varchar(20),@TEL2 varchar(20)', @EmpID = -4, @EmpNo = '1149', @EmpName = 'TEST', @Birthday = NULL, @Gender = N'男', @Nation = NULL, @IdentityNo = NULL, @Marrige = NULL, @DeptCode = '001', @DeptName = N'001', @WorkType = NULL, @Position = NULL, @Knowledge = NULL, @GraduateTime = NULL, @SchoolName = NULL, @SpecialtyName = NULL, @HireProp = NULL, @EmpSort = NULL, @HireTime = NULL, @InductionTime = NULL, @DimissionTime = NULL, @InsuNo = NULL, @PmAccounts = NULL, @PmLastYAvgSalary = NULL, @Business = '新员工', @Grade = NULL, @ImpactGrade = NULL, @YNStop = 0, @Pcdyn = NULL, @Pic = NULL, @Pic2 = NULL, @Re = NULL, @Address = NULL, @TEL = NULL, @TEL2 = NULL
解决方案 »
- 一个SQL 2000服务器需要存放多家数据,在企业管理器中如何管理啊
- 如何写唯一包含某字符的SQL语句
- mssql更改数据角色,数据表的所有者。(数据恢复紧急再现求救100分,不够再加)
- 求一句SQL语句
- 如何将整张表中两个长文本字段(text) 连接合并成其中一个长文本字段
- 散分:答谢帮助过我的朋友:此贴分给予 Benimarunikado(彭建军)
- 如何在2003中,安装sqlserver?
- 简单问题
- 在查询器中可以有结果,但ADO执行存储过程怎么返回不了记录集呢?求解
- SQLSERVER6.5,两台独立服务器间的复制中发布任务登录失败的问题,救救我吧
- 我到哪里可以找到用于练习的数据表?
- 取前一个月的数据
exec sp_executesql N'Insert Into Rs_BasicInfo (EmpNo,EmpName,Birthday,Gender,Nation,IdentityNo,Marrige,DeptCode,DeptName,WorkType,Position,Knowledge,GraduateTime,SchoolName,SpecialtyName,HireProp,EmpSort,HireTime,InductionTime,DimissionTime,InsuNo,PmAccounts,PmLastYAvgSalary,Business,Grade,ImpactGrade,YNStop,Pcdyn,Pic,Pic2,Re,Address,TEL,TEL2) Values (@EmpID,@EmpNo,@EmpName,@Birthday,@Gender,@Nation,@IdentityNo,@Marrige,@DeptCode,@DeptName,@WorkType,@Position,@Knowledge,@GraduateTime,@SchoolName,@SpecialtyName,@HireProp,@EmpSort,@HireTime,@InductionTime,@DimissionTime,@InsuNo,@PmAccounts,@PmLastYAvgSalary,@Business,@Grade,@ImpactGrade,@YNStop,@Pcdyn,@Pic,@Pic2,@Re,@Address,@TEL,@TEL2)', N'@EmpID int,@EmpNo varchar(30),@EmpName varchar(10),@Birthday datetime,@Gender nvarchar(60),@Nation nvarchar(60),@IdentityNo varchar(20),@Marrige nvarchar(60),@DeptCode varchar(12),@DeptName nvarchar(40),@WorkType nvarchar(60),@Position nvarchar(60),@Knowledge nvarchar(60),@GraduateTime datetime,@SchoolName nvarchar(60),@SpecialtyName nvarchar(60),@HireProp nvarchar(60),@EmpSort nvarchar(60),@HireTime datetime,@InductionTime datetime,@DimissionTime datetime,@InsuNo nvarchar(60),@PmAccounts nvarchar(60),@PmLastYAvgSalary nvarchar(60),@Business varchar(20),@Grade varchar(20),@ImpactGrade int,@YNStop bit,@Pcdyn bit,@Pic image,@Pic2 image,@Re nvarchar(60),@Address varchar(200),@TEL varchar(20),@TEL2 varchar(20)', @EmpID = -4, @EmpNo = '1149', @EmpName = 'TEST', @Birthday = NULL, @Gender = N'男', @Nation = NULL, @IdentityNo = NULL, @Marrige = NULL, @DeptCode = '001', @DeptName = N'001', @WorkType = NULL, @Position = NULL, @Knowledge = NULL, @GraduateTime = NULL, @SchoolName = NULL, @SpecialtyName = NULL, @HireProp = NULL, @EmpSort = NULL, @HireTime = NULL, @InductionTime = NULL, @DimissionTime = NULL, @InsuNo = NULL, @PmAccounts = NULL, @PmLastYAvgSalary = NULL, @Business = '新员工', @Grade = NULL, @ImpactGrade = NULL, @YNStop = 0, @Pcdyn = NULL, @Pic = NULL, @Pic2 = NULL, @Re = NULL, @Address = NULL, @TEL = NULL, @TEL2 = NULL
exec sp_executesql
N'Insert Into Rs_BasicInfo
(EmpNo,EmpName,Birthday,Gender,Nation,IdentityNo,Marrige,
DeptCode,DeptName,WorkType,Position,Knowledge,GraduateTime,
SchoolName,SpecialtyName,HireProp,EmpSort,HireTime,InductionTime,
DimissionTime,InsuNo,PmAccounts,PmLastYAvgSalary,Business,Grade,
ImpactGrade,YNStop,Pcdyn,Pic,Pic2,Re,Address,TEL,TEL2)
Values
(@EmpID,@EmpNo,@EmpName,@Birthday,@Gender,@Nation,@IdentityNo,
@Marrige,@DeptCode,@DeptName,@WorkType,@Position,@Knowledge,
@GraduateTime,@SchoolName,@SpecialtyName,@HireProp,@EmpSort,
@HireTime,@InductionTime,@DimissionTime,@InsuNo,@PmAccounts,
@PmLastYAvgSalary,@Business,@Grade,@ImpactGrade,@YNStop,
@Pcdyn,@Pic,@Pic2,@Re,@Address,@TEL,@TEL2)',
N'@EmpID int,@EmpNo varchar(30),@EmpName varchar(10),@Birthday datetime,
@Gender nvarchar(60),@Nation nvarchar(60),@IdentityNo varchar(20),
@Marrige nvarchar(60),@DeptCode varchar(12),@DeptName nvarchar(40),
@WorkType nvarchar(60),@Position nvarchar(60),@Knowledge nvarchar(60),
@GraduateTime datetime,@SchoolName nvarchar(60),@SpecialtyName nvarchar(60),
@HireProp nvarchar(60),@EmpSort nvarchar(60),@HireTime datetime,
@InductionTime datetime,@DimissionTime datetime,@InsuNo nvarchar(60),
@PmAccounts nvarchar(60),@PmLastYAvgSalary nvarchar(60),@Business varchar(20),
@Grade varchar(20),@ImpactGrade int,@YNStop bit,@Pcdyn bit,@Pic image,
@Pic2 image,@Re nvarchar(60),@Address varchar(200),@TEL varchar(20),
@TEL2 varchar(20)', @EmpID = -4, @EmpNo = '1149', @EmpName = 'TEST',
@Birthday = NULL, @Gender = N'男', @Nation = NULL, @IdentityNo = NULL,
@Marrige = NULL, @DeptCode = '001', @DeptName = N'001', @WorkType = NULL,
@Position = NULL, @Knowledge = NULL, @GraduateTime = NULL, @SchoolName = NULL,
@SpecialtyName = NULL, @HireProp = NULL, @EmpSort = NULL, @HireTime = NULL,
@InductionTime = NULL, @DimissionTime = NULL, @InsuNo = NULL, @PmAccounts = NULL,
@PmLastYAvgSalary = NULL, @Business = '新员工', @Grade = NULL, @ImpactGrade = NULL,
@YNStop = 0, @Pcdyn = NULL, @Pic = NULL, @Pic2 = NULL, @Re = NULL, @Address = NULL,
@TEL = NULL, @TEL2 = NULL
@EmpID = -4?