Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL Server Barcodes Expand / Collapse
Author
Message
Posted Thursday, August 4, 2005 6:38 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mcoles/sqlserverbarcodes.asp
Post #207719
Posted Tuesday, September 13, 2005 1:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 10, 2007 11:14 PM
Points: 24, Visits: 2

I am a little confused  looking at the title of the article, i was expecting of some way to print barcodes using SQL !!!!!

I think, the title of article is not appropriate..




Post #219058
Posted Tuesday, September 13, 2005 6:25 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, December 11, 2008 6:34 AM
Points: 606, Visits: 12

Nice piece of code, Mike. 

From what I see, one needs to simply use the correct font (after validating characters) to print directly from SQL--is this correct?

Also, do any other TTFs exist for other symbologies such as UPC?

Dan




Post #219131
Posted Tuesday, September 13, 2005 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 1, 2012 11:17 AM
Points: 19, Visits: 19
Awesome article!  Very helpful.  Until now I have been stuck with an ancient 3rd party tool(I know there are newer ones) and MS Access as the reporting vehicle.  I am psyched to integrate this into Reproting Services. . .
Post #219132
Posted Tuesday, September 13, 2005 7:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28, Visits: 6

Great code.  Thanks 




Post #219150
Posted Tuesday, September 13, 2005 8:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132

Thanks for the feedback.  You are correct - the TTF fonts can be used to print from most applications.  SQL Server doesn't provide much in the way of direct user input/output, and that's normally handled by a front end application.  Storing your barcode text in a database and generating the barcodes through the UI should be fairly easy with the TTFs installed (see sample application).

There are other symbologies available, but generally they cost $$$.  I focused on Code 39 and Code-128, because I couldn't find a good free Code-128 font.  I haven't created any other TTFs yet myself, although UPC/EAN would not be overly difficult; though the rules for actually assembling a UPC/EAN barcode can be a little tricky.

Post #219192
Posted Tuesday, September 13, 2005 8:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132

I originally titled it "Barcode Toolkit", but it was modified.

Post #219195
Posted Tuesday, September 13, 2005 8:07 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Great!  If you don't mind, I'd love an update on your work in that area; I'm sure it would be helpful to others (myself included)!  Thanks.
Post #219197
Posted Tuesday, September 13, 2005 8:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Thanks, and enjoy!
Post #219198
Posted Tuesday, September 13, 2005 9:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 21, 2005 4:18 PM
Points: 1, Visits: 1
very cool, save it in my personal collection
Post #219232
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse