深圳网站建设技术博客

/****** Object:  StoredProcedure [dbo].[sp_insert_cj_company_directory_list]    Script Date: 2019-6-26 11:27:09 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: yangquan

-- Create date: 20190626

-- Description: 添加列表，检查是否重复，不重复就添加

-- =============================================

ALTER PROCEDURE [dbo].[sp_insert_cj_company_directory_list] 

-- Add the parameters for the stored procedure here

@wt_url nvarchar(500) 

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

 

    -- Insert statements for procedure here

 

 

--判断页数是否超出范围

DECLARE @all_count int

BEGIN

 

    SELECT  @all_count =count(*)   from wd_cj_company_directory_list where wt_url= @wt_url

 

END

 

IF @all_count<1

 

BEGIN

insert into wd_cj_company_directory_list(wt_url) values(@wt_url ) 

END

 

 

END