交货地点被引用判断存储过程.sql

BOS大赛培训认证+-+样例代码

-------------------------------------------交货地点被引用判断存储过程-------------------------------------------------------------------
if exists (select * from sysobjects where id = object_id(N'[dbo].[sProcName]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[sProcName]

GO

 

CREATE PROCEDURE sProcName 

@classid int,

@id int,

@ret int output,

@retInfo varchar(200) output

AS

select @ret=1

if @classid=200000000

    begin

     if exists(select * from t_BOS200000001 where FFetchAdd=@id) 

        begin   

               select @retInfo='当前资料被抽样标准引用' 

            return

        end

    end

select @ret=0

return