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