自己编写一个SQL Server中用的lastindexof函数
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gifCREATE FUNCTION dbo.lastindexof (@stringValue as nvarchar(1000), @stringSearch as nvarchar(1000), @startPosition as int = 0)http://didasoft.iyunv.com/Images/OutliningIndicators/None.gifreturns int
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gifAS
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gifBEGIN
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif DECLARE @lastindex int
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif SET @lastindex= @startPosition
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif DECLARE @tempindex int
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif while (1=1)
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif begin
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif SET @tempindex = charindex(@stringSearch, @stringValue, @lastindex + 1)
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif if (@tempindex = 0)
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif break
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif SET @lastindex = @tempindex
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif end
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif RETURN(@lastindex)
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gifEND
http://didasoft.iyunv.com/Images/OutliningIndicators/None.gif
页:
[1]