if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_工資發放歷史表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[工資發放歷史表] DROP CONSTRAINT FK_工資發放歷史表_職員基本信息表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_月工資統計表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[月工資統計表] DROP CONSTRAINT FK_月工資統計表_職員基本信息表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_職員懲罰表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[職員懲罰表] DROP CONSTRAINT FK_職員懲罰表_職員基本信息表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計算_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[mrp物料需求計算] DROP CONSTRAINT mrp物料需求計算_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計算結果_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[mrp物料需求計算結果] DROP CONSTRAINT mrp物料需求計算結果_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求歷史_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[mrp物料需求歷史] DROP CONSTRAINT mrp物料需求歷史_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清單_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[物料清單] DROP CONSTRAINT 物料清單_物料編號_fk
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_分錄表_憑證表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[分錄表] DROP CONSTRAINT FK_分錄表_憑證表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期匯總賬簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[本期匯總賬簿] DROP CONSTRAINT 本期匯總賬簿_科目代碼_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期明細賬簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[本期明細賬簿] DROP CONSTRAINT 本期明細賬簿_科目代碼_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
alter TABLE [dbo].[分錄表] DROP CONSTRAINT 分錄表_科目代碼_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書丟失_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
alter TABLE [dbo].[圖書丟失] DROP CONSTRAINT 圖書丟失_圖書編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_圖書罰款_圖書信息]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
alter TABLE [dbo].[圖書罰款] DROP CONSTRAINT FK_圖書罰款_圖書信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書歸還_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
alter TABLE [dbo].[圖書歸還] DROP CONSTRAINT 圖書歸還_圖書編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書借閱_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
alter TABLE [dbo].[圖書借閱] DROP CONSTRAINT 圖書借閱_圖書編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_圖書征訂_圖書信息]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
alter TABLE [dbo].[圖書征訂] DROP CONSTRAINT FK_圖書征訂_圖書信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書注銷_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
alter TABLE [dbo].[圖書注銷] DROP CONSTRAINT 圖書注銷_圖書編號_fk
A windows BMP file is a common image format that Java does not handle. While BMP images are used only on windows machines, they are reasonably common. Reading these shows how to read complex structures in Java and how to alter they byte order from the big endian order used by Java to the little endian order used by the windows and the intel processor.
The code, images and designs for this book are released under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.
http://creativecommons.org/licenses/by-nc-sa/2.5/
You are free:
* to copy, distribute, display, and perform the work
* to make derivative works
Under the following conditions:
*Attribution. You must attribute the work in the manner specified by the author or licensor.
*Noncommercial. You may not use this work for commercial purposes.
*Share Alike. If you alter, transform, or build upon this work, you may distribute the resulting work only under a license identical to this one.
*For any reuse or distribution, you must make clear to others the license terms of this work.
*Any of these conditions can be waived if you get permission from the copyright holder.
CONTACT ME
Please address any questions to info@andybudd.com.
/* Check_SST_39VF400A Check manufacturer and device ID
/* CFI_Query CFI Query Entry/Exit command sequence
/* Erase_One_Sector Erase a sector of 2048 words
/* Erase_One_Block Erase a block of 32K words
/* Erase_Entire_Chip Erase the contents of the entire chip
/* Program_One_Word alter data in one word
/* Program_One_Sector alter data in 2048 word sector
/* Program_One_Block alter data in 32K word block
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields
Name Function
--- --- --- --- --- ---
Check_SST_39VF160 Check manufacturer and device ID
CFI_Query CFI Query Entry/Exit command sequence
Erase_Entire_Chip Erase the contents of the entire chip
Erase_One_Sector Erase a sector of 2048 word
Erase_One_Block Erase a block of 32K word
Program_One_Word alter data in one word
Program_One_Sector alter data in 2048 word sector
Program_One_Block alter data in 32K word block
Check_Toggle_Ready End of internal program or erase detection using
Toggle bit
Check_Data_Polling End of internal program or erase detection using
Data# polling
