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 s.name + '.' + o.name = @tmpTable) begin RAISERROR ('Are you freak''in crazy, you cannot drop tables in this database! Go talk to Anthony!', 10, 1); ROLLBACK; end end


Calendar

<<  January 2018  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar

About the author

Merdad Aboudizadeh is the architect and creator of office exchange software

Sign in