检查一下表是不是存在:USE master;
GOset quoted_identifier OFF
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[distributors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[distributors]
GO
GOset quoted_identifier OFF
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[distributors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[distributors]
GO
GOset quoted_identifier OFF
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[distributors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[distributors]
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[hsienshi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[hsienshi]
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[items]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[items]
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[orders]
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[products]
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[suppliers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[suppliers]
GOCREATE DATABASE TradeDBGOUSE TradeDB;GOCREATE TABLE [dbo].[hsienshi] (
[hsienshi_code] [char] (3) NOT NULL ,
[hsienshi_name] [char] (10) NOT NULL ,
CONSTRAINT [PK_hsienshi] PRIMARY KEY NONCLUSTERED
(
[hsienshi_code]
) ON [PRIMARY]
) ON [PRIMARY]
GOCREATE TABLE [dbo].[suppliers] (
[supp_code] [char] (3) NOT NULL ,
[supp_name] [char] (15) NOT NULL ,
CONSTRAINT [PK_suppliers] PRIMARY KEY NONCLUSTERED
(
[supp_code]
) ON [PRIMARY]
) ON [PRIMARY]
GOCREATE TABLE [dbo].[products] (
[prod_num] [int] NOT NULL ,
[supp_code] [char] (3) NOT NULL ,
[description] [char] (15) NOT NULL ,
[unit_price] [money] NULL ,
CONSTRAINT [PK_products] PRIMARY KEY NONCLUSTERED
(
[prod_num],
[supp_code]
) ON [PRIMARY] ,
CONSTRAINT [FK_products_suppliers] FOREIGN KEY
(
[supp_code]
) REFERENCES [dbo].[suppliers] (
[supp_code]
)
) ON [PRIMARY]
GOCREATE TABLE [dbo].[distributors] (
[distri_num] [int] IDENTITY (1001, 1) NOT NULL ,
[boss_name] [char] (16) NOT NULL ,
[company] [char] (20) NOT NULL ,
[hsienshi_code] [char] (3) NOT NULL ,
[address] [char] (30) NOT NULL ,
[phone] [char] (12) NOT NULL ,
CONSTRAINT [PK_distributors] PRIMARY KEY NONCLUSTERED
(
[distri_num]
) ON [PRIMARY] ,
CONSTRAINT [FK_distributors_hsienshi] FOREIGN KEY
(
[hsienshi_code]
) REFERENCES [dbo].[hsienshi] (
[hsienshi_code]
)
) ON [PRIMARY]
GO
[order_num] [int] IDENTITY (101, 1) NOT NULL ,
[order_date] [datetime] NOT NULL ,
[distri_num] [int] NOT NULL ,
[paid_date] [datetime] NULL ,
CONSTRAINT [PK_orders] PRIMARY KEY NONCLUSTERED
(
[order_num]
) ON [PRIMARY] ,
CONSTRAINT [FK_orders_distributors] FOREIGN KEY
(
[distri_num]
) REFERENCES [dbo].[distributors] (
[distri_num]
)
) ON [PRIMARY]
GOCREATE TABLE [dbo].[items] (
[item_num] [int] NOT NULL ,
[order_num] [int] NOT NULL ,
[prod_num] [int] NOT NULL ,
[supp_code] [char] (3) NOT NULL ,
[quantity] [int] NOT NULL ,
[total_price] [money] NOT NULL ,
CONSTRAINT [PK_items] PRIMARY KEY NONCLUSTERED
(
[item_num],
[order_num]
) ON [PRIMARY] ,
CONSTRAINT [FK_items_orders] FOREIGN KEY
(
[order_num]
) REFERENCES [dbo].[orders] (
[order_num]
),
CONSTRAINT [FK_items_products] FOREIGN KEY
(
[prod_num],
[supp_code]
) REFERENCES [dbo].[products] (
[prod_num],
[supp_code]
)
) ON [PRIMARY]
GOinsert into hsienshi values("TPE", "台北市");
insert into hsienshi values("KAO", "高雄市");
insert into hsienshi values("TPH", "台北县");
insert into hsienshi values("TYH", "桃园县");
insert into hsienshi values("HCH", "新竹县");
insert into hsienshi values("MLH", "苗栗县");
insert into hsienshi values("TCH", "台中县");
insert into hsienshi values("CHH", "彰化县");
insert into hsienshi values("YLH", "云林县");
insert into hsienshi values("JYH", "嘉义县");
insert into hsienshi values("TNH", "台南县");
insert into hsienshi values("KHH", "高雄县");
insert into hsienshi values("PTH", "屏东县");
insert into hsienshi values("ILH", "宜兰县");
insert into hsienshi values("HLH", "花莲县");
insert into hsienshi values("TTH", "台东县");
insert into hsienshi values("PHH", "澎湖县");
insert into hsienshi values("NTH", "南投县");
insert into hsienshi values("TCC", "台中市");
insert into hsienshi values("TNC", "台南市");
insert into hsienshi values("JYC", "嘉义市");
insert into hsienshi values("KLC", "基隆市");
insert into hsienshi values("HCC", "新竹市");insert into suppliers values("HHT", "颖宏科技");
insert into suppliers values("CFC", "资丰电脑");
insert into suppliers values("WCC", "玮智资讯");
insert into suppliers values("HFT", "会方科技");
insert into suppliers values("HSC", "新硕电脑");
insert into suppliers values("FYC", "富扬资讯");
insert into suppliers values("HKC", "和康电脑");
insert into suppliers values("PRC", "百润电脑");
insert into suppliers values("NKC", "宁康电脑");insert into products values (1, "HSC", "主机板", 250);
insert into products values (1, "HFT", "主机板", 800);
insert into products values (1, "HHT", "主机板", 450);
insert into products values (2, "HSC", "只读式光驱", 126);
insert into products values (3, "HFT", "可烧录式光驱", 240);
insert into products values (4, "HFT", "中央处理器", 960);
insert into products values (4, "HSC", "中央处理器", 480);
insert into products values (5, "WCC", "鼠标", 28);
insert into products values (5, "HHT", "鼠标", 25);
insert into products values (5, "CFC", "鼠标", 19.8);
insert into products values (6, "HHT", "键盘", 36);
insert into products values (6, "CFC", "键盘", 48);
insert into products values (7, "HSC", "17 屏幕", 600);
insert into products values (8, "CFC", "17 屏幕", 840);
insert into products values (9, "CFC", "10M网卡", 20);
insert into products values (101, "PRC", "100M网卡", 88);
insert into products values (101, "FYC", "100M网卡", 68);
insert into products values (102, "FYC", "4.5G硬盘", 220);
insert into products values (102, "PRC", "4.5G硬盘", 480);
insert into products values (103, "PRC", "3.5 软驱", 20);
insert into products values (104, "PRC", "VGA卡", 58);
insert into products values (105, "PRC", "声卡", 53);
insert into products values (105, "FYC", "声卡", 80);
insert into products values (106, "PRC", "电源延长线", 23);
insert into products values (107, "PRC", "防毒软件", 70);
insert into products values (108, "FYC", "护目镜", 45);
insert into products values (109, "PRC", "天线", 30);
insert into products values (109, "FYC", "天线", 200);
insert into products values (110, "PRC", "14 屏幕", 236);
insert into products values (110, "CFC", "14 屏幕", 244);
insert into products values (110, "FYC", "14 屏幕", 228);
insert into products values (110, "HSC", "14 屏幕", 260);
insert into products values (110, "HFT", "14 屏幕", 308);
insert into products values (111, "FYC", "15 屏幕", 499);
insert into products values (112, "FYC", "15 屏幕", 549);
insert into products values (113, "FYC", "15 屏幕", 685);
insert into products values (114, "PRC", "电脑桌", 120);
insert into products values (201, "NKC", "打印纸", 37.5);
insert into products values (201, "CFC", "打印纸", 75);
insert into products values (201, "HKC", "打印纸", 90);
insert into products values (202, "NKC", "调制解调器", 174);
insert into products values (202, "HKC", "无线网卡", 230);
insert into products values (203, "NKC", "21 屏幕", 670);
insert into products values (204, "HKC", "电缆线", 45);
insert into products values (205, "NKC", "4G硬盘", 312);
insert into products values (205, "CFC", "4G硬盘", 312);
insert into products values (205, "HSC", "4G硬盘", 312);
insert into products values (301, "NKC", "点阵式打印机", 97);
insert into products values (301, "HSC", "点阵式打印机", 42.5);
insert into products values (301, "FYC", "点阵式打印机", 102);
insert into products values (301, "PRC", "点阵式打印机", 75);
insert into products values (301, "HKC", "点阵式打印机", 87);
insert into products values (301, "CFC", "点阵式打印机", 95);
insert into products values (302, "HSC", "键盘转接头", 4.5);
insert into products values (302, "HKC", "键盘转接头", 5);
insert into products values (303, "PRC", "光盘", 48);
insert into products values (303, "HKC", "光盘", 36);
insert into products values (304, "CFC", "2G硬盘", 170);
insert into products values (304, "HSC", "2G硬盘", 280);
insert into products values (305, "HSC", "传真纸", 48);
insert into products values (306, "PRC", "1G硬盘", 160);
insert into products values (306, "FYC", "1G硬盘", 190);
insert into products values (307, "PRC", "2.5G硬盘", 280);
insert into products values (309, "PRC", "耳机", 40);
insert into products values (309, "FYC", "耳机", 40);
insert into products values (310, "FYC", "音箱", 80);
insert into products values (310, "CFC", "音箱", 84);
insert into products values (311, "FYC", "鼠标垫", 48);
insert into products values (312, "FYC", "ISDN卡", 96);
insert into products values (312, "HSC", "ISDN卡", 72);
insert into products values (313, "FYC", "UPS", 60);
insert into products values (313, "CFC", "UPS", 60);
"基隆路2段13号之3", "0229178129");
insert into distributors values ("李进中", "迅美科技", "TPE",
"复兴南路2段83巷12号", "0223588450");
insert into distributors values ("张江悦", "亚都电脑", "TPE",
"南京东路1段25巷9号", "0229826543");
insert into distributors values ("张胜明", "志欣资讯", "TPE",
"木新路3段310巷12弄8号之4", "0227816590");
insert into distributors values ("张鸿文", "杰印电脑", "TPE",
"南京东路4段50号之3", "0227111029");
insert into distributors values ("林文渊", "进和资讯", "TPE",
"民权东路6段207号", "0229312954");
insert into distributors values ("林宏明", "皓远科技", "TPE",
"兴隆路2段203巷11号", "0227738793");
insert into distributors values ("林金勇", "新州电脑", "TPE",
"师大路184号", "0223675806");
insert into distributors values ("周志发", "意佳科技", "TPE",
"忠孝东路1段85号之12", "0227817894");
insert into distributors values ("周宏祥", "华兴资讯", "TPE",
"长春路172巷8号", "0225422348");
insert into distributors values ("周圣林", "长佑实业", "TPE",
"庄敬路235巷42号", "0228673214");
insert into distributors values ("赵正武", "寄异国际", "TPE",
"敦化北路185号5楼", "0229315389");
insert into distributors values ("钱英仁", "保华工业", "TPE",
"和平东路2段121巷3号", "0229872154");
insert into distributors values ("孙一鸣", "万众资讯", "TPE",
"金华街86号", "0223814024");
insert into distributors values ("吴荣辉", "建功电脑", "TPE",
"仁爱路2段71号5楼", "0225439875");
insert into distributors values ("郑明典", "恒祥科技", "TPE",
"吉林路142之1号6楼", "0227219204");
insert into distributors values ("王忠伟", "启先电脑", "TPE",
"杭州南路1段27号", "0228549310");
insert into distributors values ("秦祖和", "永馀资讯", "TPE",
"长安东路2段81号", "0226549812");
insert into distributors values ("陈崇刚", "文泰科技", "TPH",
"罗斯福路3段200号12楼", "0225642319");
insert into distributors values ("陈信德", "天河资讯", "TYH",
"治平路2段97号", "036549812" );
insert into distributors values ("江仁义", "南阳实业", "ILH",
"富强路2段14巷34号", "033456129" );
insert into distributors values ("项立明", "松雨资讯", "TPH",
"新庄路2段54号2楼", "0227868567");
insert into distributors values ("曾嘉文", "怡佳企业", "HCH",
"建功二路34号4楼", "033917534" );
insert into distributors values ("黄孟正", "常毅资讯", "TNC",
"大学路54号3楼", "062732853" );
insert into distributors values ("邱振民", "文林贸易", "KAO",
"中山路1段87号5楼", "077269876" );
insert into distributors values ("洪仁中", "明湖科技", "TCC",
"建国北路一段110号", "042876436" );
insert into distributors values ("饱汉宗", "长甫企业", "CHH",
"南郭路3段189号12楼", "027166697" );insert into orders values ("1998/05/20", 1004, "1998/07/22");
insert into orders values ("1998/05/21", 1001, "1998/06/03");
insert into orders values ("1998/05/22", 1004, "1998/06/14");
insert into orders values ("1998/05/22", 1006, NULL );
insert into orders values ("1998/05/24", 1016, "1998/06/21");
insert into orders values ("1998/05/30", 1012, NULL );
insert into orders values ("1998/05/31", 1017, NULL );
insert into orders values ("1998/06/07", 1010, "1998/07/21");
insert into orders values ("1998/06/14", 1011, "1998/08/21");
insert into orders values ("1998/06/17", 1015, "1998/08/22");
insert into orders values ("1998/06/18", 1004, "1998/08/29");
insert into orders values ("1998/06/18", 1017, NULL );
insert into orders values ("1998/06/23", 1004, "1998/07/31");
insert into orders values ("1998/06/25", 1006, "1998/07/10");
insert into orders values ("1998/06/27", 1010, "1998/08/31");
insert into orders values ("1998/06/29", 1019, NULL );
insert into orders values ("1998/07/09", 1020, NULL );
insert into orders values ("1998/07/10", 1021, "1998/08/06");insert into items values (1, 101, 1, "HSC", 1, 250);
insert into items values (1, 102, 4, "HFT", 1, 960);
insert into items values (2, 102, 3, "HFT", 1, 240);
insert into items values (1, 103, 9, "CFC", 1, 20 );
insert into items values (2, 103, 8, "CFC", 1, 840);
insert into items values (3, 103, 5, "CFC", 5, 99 );
insert into items values (1, 104, 1, "HSC", 1, 250);
insert into items values (2, 104, 2, "HSC", 1, 126);
insert into items values (3, 104, 3, "HFT", 1, 240);
insert into items values (4, 104, 1, "HFT", 1, 800);
insert into items values (1, 105, 5, "WCC", 10, 280);
insert into items values (2, 105, 5, "CFC", 10, 198);
insert into items values (3, 105, 6, "HHT", 1, 36 );
insert into items values (4, 105, 6, "CFC", 1, 8 );
insert into items values (1, 106, 5, "HHT", 5, 125);
insert into items values (2, 106, 5, "WCC", 5, 140);
insert into items values (3, 106, 5, "CFC", 5, 99 );
insert into items values (4, 106, 6, "HHT", 1, 36 );
insert into items values (5, 106, 6, "CFC", 1, 48 );
insert into items values (1, 107, 1, "HSC", 1, 250);
insert into items values (2, 107, 2, "HSC", 1, 126);
insert into items values (3, 107, 3, "HFT", 1, 240);
insert into items values (4, 107, 4, "HSC", 1, 480);
insert into items values (5, 107, 7, "HSC", 1, 600);
insert into items values (1, 108, 8, "CFC", 1, 840);
insert into items values (2, 108, 9, "CFC", 5, 100);
insert into items values (1, 109, 1, "HHT", 1, 450);
insert into items values (1, 110, 6, "HHT", 1, 36 );
insert into items values (2, 110, 6, "CFC", 1, 48 );
insert into items values (1, 111, 5, "CFC", 5, 99 );
insert into items values (1, 112, 8, "CFC", 1, 840);
insert into items values (2, 112, 9, "CFC", 10, 200);
insert into items values (1, 113, 5, "CFC", 1, 19.8);
insert into items values (2, 113, 6, "HHT", 1, 36 );
insert into items values (3, 113, 6, "CFC", 1, 48 );
insert into items values (4, 113, 9, "CFC", 2, 40 );
insert into items values (1, 114, 4, "HFT", 1, 960);
insert into items values (2, 114, 4, "HSC", 1, 480);
insert into items values (1, 115, 1, "HHT", 1, 450);
insert into items values (1, 116, 101, "FYC", 2, 136);
insert into items values (2, 116, 109, "PRC", 3, 90 );
insert into items values (3, 116, 110, "HFT", 1, 308);
insert into items values (4, 116, 114, "PRC", 1, 120);
insert into items values (1, 117, 201, "NKC", 4, 150);
insert into items values (2, 117, 202, "HKC", 1, 230);
insert into items values (3, 117, 301, "FYC", 2, 204);
insert into items values (1, 118, 307, "PRC", 2, 500);
insert into items values (2, 118, 302, "HKC", 3, 15 );
insert into items values (3, 118, 110, "PRC", 1, 236);
insert into items values (4, 118, 5, "HHT", 4, 100);
insert into items values (5, 118, 304, "HSC", 1, 280);
GOset quoted_identifier OFF
GOif exists (select * from sysobjects where id = object_id(N'[dbo].[distributors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[distributors]
GO上面那个是什么意思,是系统表吗
{
try
{
Assembly Asm = Assembly.GetExecutingAssembly();
Stream strm = Asm.GetManifestResourceStream(Asm.GetName().Name + "."+Name);
StreamReader reader = new StreamReader(strm);
return reader.ReadToEnd();
}
catch (Exception ex)
{
Console.Write("In GetSql:"+ex.Message);
throw ex;
}
} private void ExecuteSql(string DataBaseName,string Sql)
{
System.Data.SqlClient.SqlCommand Command = new System.Data.SqlClient.SqlCommand(Sql,sqlConnection1); Command.Connection.Open();
Command.Connection.ChangeDatabase(DataBaseName);
try
{
Command.ExecuteNonQuery();
}
finally
{
Command.Connection.Close();
}
}
protected void AddDBTable(string strDBName)
{
try
{
ExecuteSql("master","CREATE DATABASE "+ strDBName);
ExecuteSql(strDBName,GetSql("sql.txt"));
}
catch(Exception ex)
{
Console.Write("In exception handler :"+ex.Message);
}
} public override void Install(System.Collections.IDictionary stateSaver)
{
base.Install(stateSaver);
AddDBTable(this.Context.Parameters["dbname"]);
}
是不是sql sever或磁盘空间的问题
不是,我也试了,不能执行go,use等语句,问题我正在想办法。
restore database traddb from disk='c:\backup\databasebkp' with norecovery 先用着,再想办法
你式你的程序 行吗,第2次起同样的名可以吗
有变化吗
也不行啊if exists (select * from sysobjects where id = object_id(N'[dbo].[MK_Employees]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MK_Employees];CREATE TABLE [MK_Employees] ( [Name] [char] (30) NOT NULL , [Rsvp] [int] NULL , [Requests] [nvarchar] (4000) NULL )
ALTER TABLE [MK_Employees] WITH NOCHECK ADD CONSTRAINT [PK_MK_Employees] PRIMARY KEY NONCLUSTERED ( [Name] );INSERT [MK_Employees] ( [Name] , [Rsvp] , [Requests] ) VALUES ( '1' , 11 , '11' );
INSERT [MK_Employees] ( [Name] , [Rsvp] , [Requests] ) VALUES ( '2' , 3 , '4' );
INSERT [MK_Employees] ( [Name] , [Rsvp] , [Requests] ) VALUES ( '3' , 1 , '1' );第1次这样写 ,第2次把数值改改还是无变化啊