--插入主表(EntPersonnel基础资料)
if @IDCard<>''
begin
if not exists(select 1 from EntPersonnel where IDCard=@IDCard)
begin
set @j=@j+1
insert into EntPersonnel(Name,Sex,IDCard,Tel,Res)
values(@Name,(case when @Sex='男' then 1 when @Sex='女' then 0 else '' end),@IDCard,@Tel,@Res)
set @PerID=select SCOPE_IDENTITY() --这一句出错,怎么改才能获得上一句插入ID值?
print @PerID
end
end
if @IDCard<>''
begin
if not exists(select 1 from EntPersonnel where IDCard=@IDCard)
begin
set @j=@j+1
insert into EntPersonnel(Name,Sex,IDCard,Tel,Res)
values(@Name,(case when @Sex='男' then 1 when @Sex='女' then 0 else '' end),@IDCard,@Tel,@Res)
set @PerID=select SCOPE_IDENTITY() --这一句出错,怎么改才能获得上一句插入ID值?
print @PerID
end
end
修改为如下:
set @PerID=SCOPE_IDENTITY()
select语句要这样用
select @PerID=SCOPE_IDENTITY()