|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
|
|
|
|
|
|
Grasshopper
      
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..
|
|
|
|
|
SSChasing 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
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Wednesday, August 01, 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. . .
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28,
Visits: 6
|
|
Great code. Thanks 
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
|
|
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.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
|
|
I originally titled it "Barcode Toolkit", but it was modified.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
|
|
| 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.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
|
|
|
|
|
|
Forum 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
|
|
|
|