SQL Server 2012存储过程与调用.pdfVIP

SQL-Server2012 存储过程及调用 郭晟 黑名单维护 USE [OutCallMarketing] GO /****** Object: StoredProcedure [dbo].[add_value_to_black_user_list] Script Date: 2014/2/25 16:03:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[add_value_to_black_user_list] @number_in varchar (50) as declare @number varchar (50) set @number=@number_in if len(@number)!=11 begin print 警告！号码“+@number+”不是正确的手机号码！请重新输入！ end if len(@number)=11 begin if exists(select * from dbo.STATIC_Black_User_List where number=@number) begin print 插入失败！手机号码“+@number+”已存在于黑名单中！ end if not exists(select * from dbo.STATIC_Black_User_List where number=@number) begin insert into dbo.STATIC_Black_User_List values (@number) print 插入成功！已将手机号码“+@number+”插入黑名单！ end end declare @number varchar (50) set @number= exec dbo.add_value_to_black_user_list @number 已呼号码维护 USE [OutCallMarketing] GO /****** Object: StoredProcedure [dbo].[import_called_number_from_csv] Script Date: 2014/2/25 16:05:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[import_called_number_from_csv] @csv_file_name_in varchar (50), @csv_file_path_in varchar (50), @destination_all_called_table_name_in varchar (50) as declare @csv_file_name varchar (50) set @csv_file_name=@csv_file_name_in declare @csv_file_path varchar (50) set @csv_file_path=@csv_file_path_in declare @destination_all_called_table_name varchar (50) set @destination_all_called_table_name=@destination_all_called_table_name_in if @csv_file_name= begin print 警告！请先输入CSV文件名！ end if @csv_file_path= begin print 警告！请先输入CSV文件路径！格式为“X:\PATH”！ end if @destination_all_called_table_name= begin prin