调用存储过程时指定插入参数的问题
create PROCEDURE AddEmployee
@InputIDCard varchar(max)= '000000000000000 ',
@InputEmployeeName varchar(max),
@InputJobID int=NULL,
@InputDepartmentID int=NULL,
@InputSalary money=0,
@InputEducationID int=NULL,
@InputSex bit=NULL,
@InputMaritalStatus bit=NULL,
@InputBirthDate datetime=NULL,
@InputHireDate datetime=NULL,
@InputCellPhone varchar(max)= '00000000000 ',
@InputHomePhone varchar(max)= '00000000000 ',
@InputAddress varchar(max)=NULL,
@InputPostalCode varchar(max)= '000000 ',
@InputPhoto varchar(max)=NULL,
@InputRemarks varchar(max)=NULL
参数如上。我需要在写exec addemployee 时，只调用EmployeeName这个参数执行存储过程，请问如何实现？
[解决办法]
exec addemployee ' ',EmployeeName, ' ',...
[解决办法]
其他参数设置为 ' '
exec addemployee ' ',name, ' ', .....
