BCB 編寫的一些簡單函數用于SQL的擴展存儲過程. -檢查文件是否存在Select dbo.FileExist( c:\boot.ini ) --刪除文件Select dbo.FileDelete( C:\X.txt ) --服務狀態Select dbo.ServerStat( awhost32 ,1) --建立目錄Select dbo.MKDIR( C:\Test\test ,1) --文件復制Select dbo.FileCopy( C:\boot.ini , c:\Boot\YYY.ini ,1) --刪除目錄Select dbo.RDDIR( C:\Text ,1) --鎖定計算機Select dbo.LockPc() --結束程序Select dbo.KillPorg( Notepad.exe ) --執行程序Select dbo.StartPorg( Notepad.exe ) --得到IP地址Select dbo.GetIP() --分解字符Select dbo.TextPart( 123*456*789 , * ,0) QQ:254082939 Email:haihong5995037@163.com
標簽： Select FileDelete FileExist dbo
上傳時間： 2014-01-22
上傳用戶：1109003457
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
Easydbo是由簡易java框架網(www.easyjf.com)開發的一個適合中小型軟件數據庫開發的java數據持久層框架，系統參考hibernate、JDO等，結合中小項目軟件的開發實際，實現簡單的Java對象到關系數據的映射。Easydbo由于比較簡單，比較適合于中小企業及個人開發使用，Easydbo當前還處于測試階段、是一個簡易但不太成熟的對象-關系映射開源中間件。 Easydbo的源代碼非常簡單，有一點Java知識的人基本上都能讀懂，因此，選擇Easydbo作本文的示例主要目的在于讓讀者快速進入ORM系統的世界，理解對象-關系數據庫實質及實現原理。 Easydbo考慮的是最簡單的對象－關系映射，簡單到可以不使用任何配置文件就實現對象-關系的映射。Easydbo源碼主要包括com.easyjf.dbo、com.easyjf.dbo.config、com.easyjf.dbo.sql三個包。其中com.easyjf.dbo是框架的核心、實現了對象-關系的轉換、JDBC API的封裝以及用戶接口支持等，com.easyjf.dbo.config實現配置文件的管理，com.easyjf.dbo.sql實現數據庫的簡單Sql語句的生成及多數據庫支持的擴展。
上傳時間： 2013-12-30
上傳用戶：change0329
