if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[getEPnum]'''') and xtype in (N''''FN'''', N''''IF'''', N''''TF'''')) drop function [dbo].[getEPnum] GO
if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[getstrcount]'''') and xtype in (N''''FN'''', N''''IF'''', N''''TF'''')) drop function [dbo].[getstrcount] GO
if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[getstrofindex]'''') and xtype in (N''''FN'''', N''''IF'''', N''''TF'''')) drop function [dbo].[getstrofindex] GO
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO
--- 这个函数直接调用了另外的两个函数,可以先阅读下面提到的两个函数 CREATE function getEPnum (@str varchar(8000)) returns varchar(8000) as begin declare @str_return varchar(8000) declare @i int declare @temp_i int declare @onlineornot int declare @findepnumok int