Office Exhange help Blog

Currency Exchange & Money Transfer software

Epson TM-T70 Printer

clock May 29, 2010 01:32 by author Admin
find small printer here

Front-facing controls, paper loading and receipt dispensing. The innovative, space-saving Epson TM-T70 printer with easy all-front access is the only receipt printer available today that is designed to operate entirely from the front of the printer. This means you can put it under a counter or on a shelf and free up your valuable counter space. The TM-T70 prints receipts and graphics at the same fast print speed of 170 mm/second. And with its 180 dpi resolution you are assured of crisp, clear receipts and eye-catching logos. Barcodes are also supported, including 2D. Interface options are available for USB, serial, parallel, Ethernet and wireless

create do not drop table trigger in SQL Server 2005 or 2008

clock May 26, 2010 20:41 by author Admin
ON DATABASE FOR DROP_TABLE AS begin /*Anthony Oct 2009 My cheesy attempt at preventing tables from being dropped accidently This logic only allows a table to be dropped if it can find another table with the same schema/name plus the Tmp_ prefix, this is how SQL Server Management Studio alters tables */ declare @data XML declare @table as varchar(100), @tmpTable as varchar(100) set @data = EVENTDATA() set @table = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'nvarchar(2000)') + '.' + @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'nvarchar(100)') set @tmpTable = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'nvarchar(2000)') + '.Tmp_' + @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'nvarchar(100)') --select @table as tableName,@tmpTable as Tmp_TableName if not exists (select 1 from sys.objects o join sys.schemas s on o.schema_id = s.schema_id where o.type = 'U' and + '.' + = @tmpTable) begin RAISERROR ('Are you freak''in crazy, you cannot drop tables in this database! Go talk to Anthony!', 10, 1); ROLLBACK; end end


<<  November 2019  >>

View posts in large calendar

About the author

Merdad Aboudizadeh is the architect and creator of office exchange software

Sign in