111,126
社区成员
发帖
与我相关
我的任务
分享ALTER PROCEDURE dbo.pro_insertWuzhong_1
(@namech varchar(50), @nameld varchar(50),@men varchar(50),@gang varchar(50), @mu varchar(50), @ke varchar(50),@shu varchar(50),@introduction nvarchar(max),@picture image )
as begin
declare @N int;
begin tran
insert into 物种分类目录表 (NameCH,NameLD,Men,Gang,Mu,Ke,Shu) values(@namech,@nameld,@men,@gang,@mu,@ke,@shu)
if @@error<>0
begin
rollback tran
return -1
end
set @N= @@identity;
insert into 物种详细信息表(ID,Introduction,Picture)values(@N,@introduction,@picture)
if @@error<>0
begin
rollback tran
return -1
end
commit tran
return 0
end