if you don't have values for those n parameters, you don't even need to create them, but order the parameters this way:create proc insert_mn @paramm1 varchar(10), .. @parammm varchar(10), @paramn1 varchar(10)=null, ... @paramn1n varchar(10)=null asinsert into mn (m1,..mn,n1,..nn) values (@paramm1,...@parammm,@paramn1,...@paramnn)
要不你用if @xx is null 来判断 要不就: insert xx .. values(isnull(@xx,0)...)
@paramm1 varchar(10),
..
@parammm varchar(10),
@paramn1 varchar(10)=null,
...
@paramn1n varchar(10)=null
asinsert into mn (m1,..mn,n1,..nn) values (@paramm1,...@parammm,@paramn1,...@paramnn)
要不就:
insert xx .. values(isnull(@xx,0)...)