-------------------------------------------交貨地點被引用判斷存儲過程-------------------------------------------------------------------
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