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].[產地]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[產地] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[醫生資料]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[醫生資料]
上傳時間： 2013-11-12
上傳用戶：sunshie
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_客房信息_客房類型
上傳時間： 2014-03-23
上傳用戶：chenhr
c#數據庫開發實例:有很多的實例，對學習非常的有意義！ 酒店管理系統源代碼 醫院信息管理系統源代碼 圖書館管理系統源代碼 財務管理系統源代碼 生產管理系統源代碼 人力資源管理實例程序源代碼 進銷存管理實例程序源代碼 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
上傳時間： 2013-10-30
上傳用戶：392210346
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
上傳時間： 2013-11-15
上傳用戶：wkxiian
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_職員懲罰表_職員基本信息表
上傳時間： 2014-11-17
上傳用戶：xinzhch
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
上傳時間： 2013-11-23
上傳用戶：wcl168881111111
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
上傳時間： 2013-11-20
上傳用戶：清山綠水
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
上傳時間： 2014-05-04
上傳用戶：togetsomething
MAXQUSBJTAGOW評估板軟件:關鍵特性 Easily Load and Debug Code Interface Provides In-Application Debugging Features Step-by-Step Execution Tracing Breakpointing by Code Address, Data Memory Address, or Register Access Data Memory View and Edit Supports Logic Levels from 1.1V to 3.6V Supports JTAG and 1-Wire Protocols Each Adapter Has Its Own Unique Serial ID, Allowing Multiple Adapters to be Connected Without COM Port Conflicts Has In-Field Upgradable Capability if Firmware Needs to be Upgraded Enclosure Protects from Shorts and ESD
標簽： MAXQUSBJTAGOW 評估板 軟件
上傳時間： 2013-10-24
上傳用戶：teddysha
用途：測量地磁方向，測量物體靜止時候的方向，測量傳感器周圍磁力線的方向。注意，測量地磁時候容易受到周圍磁場影響，主芯片HMC5883 三軸磁阻傳感器特點（抄自網上）： 1，數字量輸出：I2C 數字量輸出接口，設計使用非常方便。 2，尺寸小: 3x3x0.9mm LCC 封裝，適合大規模量產使用。 3，精度高：1－2 度，內置12 位A/D,OFFSET, SET/RESET 電路，不會出現磁飽和現象，不會有累加誤差。 4，支持自動校準程序，簡化使用步驟，終端產品使用非常方便。 5，內置自測試電路，方便量產測試，無需增加額外昂貴的測試設備。 6，功耗低：供電電壓1.8V, 功耗睡眠模式-2.5uA 測量模式-0.6mA 連接方法： 只要連接VCC，GND，SDA，SDL 四條線。 Arduino GND -> HMC5883L GND Arduino 3.3V -> HMC5883L VCC Arduino A4 (SDA) -> HMC5883L SDA Arduino A5 (SCL) -> HMC5883L SCL (注意，接線是A4，A5，不是D4,D5) 源程序： #include <Wire.h> #include <HMC5883L.h> HMC5883Lcompass; voidsetup() { Serial.begin(9600); Wire.begin(); compass = HMC5883L(); compass.SetScale(1.3); compass.SetMeasurementMode(Measurement_Continuous); } voidloop() { MagnetometerRaw raw = compass.ReadRawAxis(); MagnetometerScaled scaled = compass.ReadScaledAxis(); float xHeading = atan2(scaled.YAxis, scaled.XAxis); float yHeading = atan2(scaled.ZAxis, scaled.XAxis); float zHeading = atan2(scaled.ZAxis, scaled.YAxis); if(xHeading < 0) xHeading += 2*PI; if(xHeading > 2*PI) xHeading -= 2*PI; if(yHeading < 0) yHeading += 2*PI; if(yHeading > 2*PI) yHeading -= 2*PI; if(zHeading < 0) zHeading += 2*PI; if(zHeading > 2*PI) zHeading -= 2*PI; float xDegrees = xHeading * 180/M_PI; float yDegrees = yHeading * 180/M_PI; float zDegrees = zHeading * 180/M_PI; Serial.print(xDegrees); Serial.print(","); Serial.print(yDegrees); Serial.print(","); Serial.print(zDegrees); Serial.println(";"); delay(100); }
上傳時間： 2013-12-16
上傳用戶：stella2015
