c#數(shù)據(jù)庫開發(fā)實(shí)例:有很多的實(shí)例，對(duì)學(xué)習(xí)非常的有意義！
酒店管理系統(tǒng)源代碼
醫(yī)院信息管理系統(tǒng)源代碼
圖書館管理系統(tǒng)源代碼
財(cái)務(wù)管理系統(tǒng)源代碼
生產(chǎn)管理系統(tǒng)源代碼
人力資源管理實(shí)例程序源代碼
進(jìn)銷存管理實(shí)例程序源代碼
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].[進(jìn)貨單_供貨商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)貨單] DROP CONSTRAINT 進(jìn)貨單_供貨商_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)計(jì)表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[月工資統(tǒng)計(jì)表] DROP CONSTRAINT FK_月工資統(tǒng)計(jì)表_職員基本信息表
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物料需求計(jì)算_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計(jì)算] DROP CONSTRAINT mrp物料需求計(jì)算_物料編號(hào)_fk
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計(jì)算結(jié)果_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計(jì)算結(jié)果] DROP CONSTRAINT mrp物料需求計(jì)算結(jié)果_物料編號(hào)_fk
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求歷史_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求歷史] DROP CONSTRAINT mrp物料需求歷史_物料編號(hào)_fk
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清單_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[物料清單] DROP CONSTRAINT 物料清單_物料編號(hào)_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].[本期明細(xì)賬簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本期明細(xì)賬簿] DROP CONSTRAINT 本期明細(xì)賬簿_科目代碼_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].[圖書丟失_圖書編號(hào)_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書丟失] DROP CONSTRAINT 圖書丟失_圖書編號(hào)_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].[圖書歸還_圖書編號(hào)_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書歸還] DROP CONSTRAINT 圖書歸還_圖書編號(hào)_fk
go
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書借閱_圖書編號(hào)_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書借閱] DROP CONSTRAINT 圖書借閱_圖書編號(hào)_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].[圖書注銷_圖書編號(hào)_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書注銷] DROP CONSTRAINT 圖書注銷_圖書編號(hào)_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
