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
2^x mod n = 1 acm競賽題 Give a number n, find the minimum x that satisfies 2^x mod n = 1.
Input
One positive integer on each line, the value of n.
Output
If the minimum x exists, print a line with 2^x mod n = 1.
Print 2^? mod n = 1 otherwise.
You should replace x and n with specific numbers.
Sample Input
2
5
Sample Output
2^? mod 2 = 1
2^4 mod 5 = 1
Contains source to demonstrate how to copy/delete files and folders with HFS+ APIs. It also demonstrates a technique to rename an object if an object of the same name exists in the destination.
This sample shows how to perform these operations in an MP-safe way.
Huo Chess by Spiros (Spyridon) Kakos (http://www.kakos.com.gr) is a micro chess program in CLI C++ v8.0 that attempts to be smaller in size than the Commodore-era Microchess. The goal is to create the smallest chess program that exists. More versions are to come in the future.
Sqlserver2000壓力測試
數據庫請自己建，附腳本。不懂的可以發郵件問我：killwolf@163.com
10萬
109640ms 插入
23078ms 清空
20萬
216281ms
8391馬上
40萬：
416781
9381
if exists (select * from dbo.sysobjects where id = object_id(N [dbo].[StuInfo] ) and OBJECTPROPERTY(id, N IsUserTable ) = 1)
drop table [dbo].[StuInfo]
GO
CREATE TABLE [dbo].[StuInfo] (
[StuID] [float] NULL
) ON [PRIMARY]
GO
The USB Multi-Interface driver is a replacement driver for the system provided Multi-Interface driver. This driver was developed to overcome some bugs that are included in the build in driver and to introduce new features. The driver is compatible to the system provided Multi-Interface driver. If the driver is installed on a system, it does not automatically replace the system provided driver. It exists parallel to the system driver and is assigned to a device during the installation process.
In an electromagnetic cloak based on a transformation approach, reduced sets of
material properties are generally favored due to their easier implementation in reality,
although a seemingly inevitable drawback of undesired reflection exists in such cloaks.
Here we suggest using high-order transformations to create smooth moduli at the outer
boundary of the cloak, therefore completely eliminating the detrimental scattering
within the limit of geometric optics. We apply this scheme to a non-magnetic
cylindrical cloak and demonstrate that the scattered field is reduced substantially in a
cloak with optimal quadratic transformation as compared to its linear counterpart.
program which uses hashing techniques for storing and retrieving the data.
Input to the program: Some random numbers. Input will be from a file.
Output: First the program reads all the input and store it properly using some hash techniques.
Once your program reads the complete input,it waits for the user input (prompt to the user).
User now enters some number.program displays if this number exists in the list or not.
it also display the time taken in the search operation.
