(turn) SQL-based EAN-13 barcode check bit generation

Source: http://bbs.csdn.net/topics/220057226

Create FUNCTION dbo. EAN_13 (@value varchar (13))
Returns varchar (13)
As
Begin
declare @s1 int, @s2 int

Declare @t table (ID int identity (), b bit)

INSERT INTO @t (b)
Select top 1 from syscolumns

Set @value = ' 0 ' +reverse (@value)

Select @s1 =sum (CAST (substring (@value, id,1) as int)
From @t A
where Len (@value) >=id and id%2=0

Set @[email protected]*3

Select @s2 =sum (CAST (substring (@value, id,1) as int)
From @t A
where Len (@value) >=id and Id>=3 and Id%2=1

Set @[email Protected][email protected]
Return left (reverse (@value), +ltrim) (10-len (@s1))
End
Go

SELECT dbo. Ean_13 (' 234235654652 ') ean13
Go

Drop function ean_13

/*
Ean13
-------------
2342356546528

(The number of rows affected is 1 rows)
*/

(turn) SQL-based EAN-13 barcode check bit generation