判断附件是否存在如果存在就返回已有的正常数据Id
declare @OutInt int;
select @OutInt = Id from FujianInfo where fujianName = @FujianName and FujianAdd =@FujianAdd;
if (@OutInt=0 or @OutInt is null) --等于0就插入数据
begin
INSERT [FujianInfo](
[FujianName],
[FujianAdd],
[FujianType],
[CreateDate],
[Creator]
)VALUES(
@FujianName,
@FujianAdd,
@FujianType,
getdate(),
@Creator);
select @OutInt = @@IDENTITY;
end
;SELECT @OutInt