--Dar de alta impresoras portátiles
Declare @name varchar(7) = 'Porta10' --Aqui es el nombre que tendrá la impresora
Declare @IPS varchar(30) = '10.245.245.156' --Aqui va la ip que se asignará a la impresora
INSERT INTO [dbo].[Printer]
([PhysicalPrinter]
,[Description]
,[ShortName]
,[PrintServer]
,[PrinterModel]
,[Port]
,[Mobile]
,[Ip]
,[HandheldId]
,[BlockDate]
,[NotificationState]
,[NotificateTo])
VALUES
(@name,
@name,
@name,
'Standard TCP/IP Port',
'ZDesigner QLn320 (ZPL)',
6101,
1,
@IPS,
NULL,
NULL,
NULL,
NULL)
select * from printer where mobile=1
--update Printer SET HandheldId = NULL , BlockDate = NULL, NotificateTo=NULL, NotificationState=NULL where MOBILE = 1 