22,207
社区成员
发帖
与我相关
我的任务
分享
ALTER FUNCTION [dbo].[getLWH]
(
@LWH NVARCHAR(50),
@TYPE NVARCHAR(50)
)
RETURNS NVARCHAR(50)
BEGIN
DECLARE @LENGTH NVARCHAR(50),@WIDTH NVARCHAR(50),@HEIGHT NVARCHAR(50),@TLEN INT,@TEMP NVARCHAR(50)
IF CHARINDEX('*',@LWH)<>0
SET @LENGTH = SUBSTRING(@LWH,1,CHARINDEX('*',@LWH)-1)
SET @TEMP = SUBSTRING(@LWH,CHARINDEX('*',@LWH)+1,LEN(@LWH)-CHARINDEX('*',@LWH))
SET @WIDTH = SUBSTRING(@TEMP,1,CHARINDEX('*',@TEMP)-1) --NOT VERY CLEAR
SET @HEIGHT = SUBSTRING(@TEMP,CHARINDEX('*',@TEMP)+1,LEN(@TEMP)-CHARINDEX('*',@TEMP))
--SUBSTRING(@TEMP,CHARINDEX('*'@TEMP)+1,LEN(@TEMP)-CHARINDEX('*',@TEMP))
IF CHARINDEX('×',@LWH)<>0
SET @LENGTH = SUBSTRING(@LWH,1,CHARINDEX('×',@LWH)-1)
SET @TEMP = SUBSTRING(@LWH,CHARINDEX('×',@LWH)+1,LEN(@LWH)-CHARINDEX('×',@LWH))
SET @WIDTH = SUBSTRING(@TEMP,1,CHARINDEX('×',@TEMP)-1) --NOT VERY CLEAR
SET @HEIGHT = SUBSTRING(@TEMP,CHARINDEX('×',@TEMP)+1,LEN(@TEMP)-CHARINDEX('×',@TEMP))
IF CHARINDEX('*',@LWH)=0 AND CHARINDEX('×',@LWH)=0 AND CHARINDEX('.',@LWH)=0
SET @TLEN = LEN(@LWH)
SET @LENGTH = SUBSTRING(@LWH,1,@TLEN-8)
SET @WIDTH = SUBSTRING(@LWH,@TLEN-7,4)
SET @HEIGHT = SUBSTRING(@LWH,@TLEN-3,4)
IF @LWH='8.82.42.92'
SET @LENGTH ='8.8'
SET @WIDTH ='2.4'
SET @HEIGHT='2.92'
IF @LWH='9.882.433.25'
SET @LENGTH ='9.88'
SET @WIDTH ='2.43'
SET @HEIGHT='3.25'
IF @LWH='10.5052.53.04'
SET @LENGTH ='10.505'
SET @WIDTH ='2.5'
SET @HEIGHT='3.04'
IF @LWH='5995'
SET @LENGTH=''
SET @WIDTH=''
SET @HEIGHT=''
IF @LWH='2010.11.02'
SET @LENGTH=''
SET @WIDTH=''
SET @HEIGHT=''
IF @LWH='0'
SET @LENGTH=''
SET @WIDTH=''
SET @HEIGHT=''
IF @LWH='G690HB00063'
SET @LENGTH=''
SET @WIDTH=''
SET @HEIGHT=''
IF @TYPE='L'
RETURN @LENGTH
IF @TYPE='W'
RETURN @WIDTH
IF @TYPE='H'
RETURN @HEIGHT
RETURN ''
END