c#數(shù)據(jù)庫開發(fā)實例:有很多的實例，對學(xué)習(xí)非常的有意義！
酒店管理系統(tǒng)源代碼
醫(yī)院信息管理系統(tǒng)源代碼
圖書館管理系統(tǒng)源代碼
財務(wù)管理系統(tǒng)源代碼
生產(chǎn)管理系統(tǒng)源代碼
人力資源管理實例程序源代碼
進銷存管理實例程序源代碼
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].[采購訂單_供貨商_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
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_工資發(fā)放歷史表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[工資發(fā)放歷史表] DROP CONSTRAINT FK_工資發(fā)放歷史表_職員基本信息表
Go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_月工資統(tǒng)計表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[月工資統(tǒng)計表] DROP CONSTRAINT FK_月工資統(tǒng)計表_職員基本信息表
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物料需求計算結(jié)果_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計算結(jié)果] DROP CONSTRAINT mrp物料需求計算結(jié)果_物料編號_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
This application note provides a functional description of VHDL source code for a N x N DigitalCrosspoint Switch. The code is designed with eight inputs and eight outputs in order to targetthe 128-macrocell CoolRunner™-II CPLD device but can be easily expanded to target higherdensity devices. To obtain the VHDL source code described in this document, Go to sectionVHDL Code, page 5 for instructions.
Training embedded apps to process speech may be as easy as finding the right 8-bit micro. Don t let what Rodger has to say about using an ADPCM alGorithm and PWM output to generate speech to Go in one ear and out the other
