/****** Object: Stored Procedure dbo.GoodsDel Script Date: 2007-5-10 13:02:58 ******/
--删除员工信息
create procedure [dbo].[DelMember ]
(
@sresult int output,
@ID int --相关内部ID
)
AS
declare @result int --统计单据中存在仓库
declare @result1 int --统计单据中存在仓库
begin tran
--判断记录数
set @result=0
set @result1=0
--获取
if (@result+@result1=0)
begin
set @sresult=1
delete Member where [ID]= @ID
end
else
set @sresult=2
if(@@error=0)
commit tran
else
rollback tran
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON