Overview
This is the Epson TM-U220B SQL insert query to add the printer definition to a database that does not contain this printer device type
Prerequisites
SSMS
SQL script to excute via a new query against the affected database:
INSERT [dbo].[PrinterDefs]
([PrinterDefID], [DateUpdated], [PrinterType], [LineWidth], [PageLength], [InitCode], [ClearAllCode], [StartLineCode],
[EndLineCode], [FormFeedCode], [BeepCode], [Drawer1Code], [Drawer2Code], [FullCutCode], [PartCutCode], [SlipRelCode],
[MultiFeedCode], [MultiFeedSubst], [SetLinesCode], [SetLinesSubst], [Logo1Code], [Logo2Code], [Logo3Code], [Logo4Code],
[Logo5Code], [Logo6Code], [Logo7Code], [Logo8Code], [BoldStCode], [BoldEndCode], [RedStCode], [RedEndCode], [LrgeStCode],
[LrgeEndCode], [UndrStCode], [UndrEndCode], [Font2Code], [Font2Width], [Font3Code], [Font3Width], [NoCurrSymbol],
[CodePage], [MarginLeft], [MarginRight], [MarginTop], [MarginBottom], [SendLogoCode], [LogoMaxWidth], [StatusRqCode],
[StatusPort], [StatusByte], [StatusMask], [EANStCode], [EANEndCode], [CODE39StCode], [CODE39EndCode], [BarcodeSetPosCode],
[QRCODEStCode], [QRCODEEndCode], [QRCODELengthBytes], [QRCODESetPosCode], [QRCODESetPosCode1])
VALUES (3022, CAST(N'2019-05-30T13:50:35.000' AS DateTime), N'Epson TM-U220B', 40, 0,
N'1B401B32 ', N'1B2101 ',
N' ', N'0D0A ', N'1B6406 ', N' ',
N'1B50003CFF ', N'1B50013CFF ', N'1B64081B691B6404 ',
N'1B64081B6D1B6404 ', N' ', N' ',
0, N' ', 0, N'1C700100 ', N'1C700200 ',
N'1C700300 ', N'1C700400 ', N'1C700500 ',
N'1C700600 ', N'1C700700 ', N'1C700800 ',
N'1B4501 ', N'1B4500 ', N'1B7201 ',
N'1B7200 ', N'1B2133 ', N'1B2101 ',
N'1B2D01 ', N'1B2D00 ', N' ',
0, N' ', 0, 0, 1252, 0, 0, 0, 0, N'1C71 ', 592,
N'4550534f4e510300001000000000 ', -3289, 14, 1, N'1D48021D68601D6B02 ', N'00 ',
N'1D48021D68601D6B04 ', N'00 ', N'1D440A0009 ',
N' ',
N' ', 0, N' ', N' ')