python ean13条形码的验证_(转)基于SQL的EAN13、ENA8条形码校验位生成

USE [DB]

GO

/****** Object: UserDefinedFunction [dbo].[EAN13] Script Date: 07/04/2017 15:21:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/**

--功能：获取EAN-13码的检验位

--Author:josy(百年树人)

--参数@s:EAN-13码前12位

**/

ALTER function [dbo].[EAN13](@s char(12))

returns varchar(1)

as

begin

return (10-(

(cast(substring(@s,2,1) as int)+substring(@s,4,1)+substring(@s,6,1)

+substring(@s,8,1)+substring(@s,10,1)+substring(@s,12,1)

)*3

+substring(@s,1,1)+substring(@s,3,1)+substring(@s,5,1)

+substring(@s,7,1)+substring(@s,9,1)+substring(@s,11,1)

)%10)%10

end

create function dbo.EAN8 (@value varchar(8))

returns varchar(8)

as