资源描述:
《数据库实验1sql语句》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、createtablesalvaging(prj_numchar(8)primarykey,pri_namevarchar(50),start_datedatetime,end_datedatetime,prj_statusbit);创建stockcreatetablestock(mat_numchar(8)primarykey,mat_namevarchar(50)notnull,specivarchar(20)notnull,warehousevarchar(50),amountint,unitdecimal(18,2
2、),totalas([amount]*[unit]));创建out_stockcreatetableout_stock(prj_numchar(8),mat_numchar(8),amountint,get_datedatetime,departmentvarchar(100),primarykey(prj_num,mat_num),foreignkey(prj_num)referencessalvaging(prj_num),foreignkey(mat_num)referencesstock(mat_num),);插入
3、到salvaginginsertintodbo.salvagingvalues('20100015','220KV清经线接地箱及接地线被盗抢修',2010-10-12,2010-10-13,1);insertintosalvagingvalues('20100016','沙河站#公变出线电缆老化烧毁抢修',2010-11-05,2010-11-05,1);insertintosalvagingvalues('20110001','西丽站电缆短路烧毁抢修工程',2011-01-03,2011-01-03,1);inserti
4、ntosalvagingvalues('20110002','西丽站电缆接地抢修',2011-01-03,2011-01-05,1);insertintosalvagingvalues('20110003','观澜站光缆抢修',2011-02-10,2011-02-11,1);insertintosalvagingvalues('20110004','小径墩低压线被盗抢修',2012-02-15,2011-02-15,1);insertintosalvagingvalues('20110005','明珠立交电缆沟盖板破损抢
5、修',2011-03-02,2011-03-05,0);insertintosalvagingvalues('20110010','朝阳围公变低压线被盗抢修',2011-03-08,2011-03-11,1);插入到stockinsertintostockvalues('m001','护套绝缘电线','BVV-120','供电局#仓库',220,89.80);insertintostockvalues('m002','架空绝缘电线','10KV-150','供电局#仓库',30,17.00);insertintostock
6、values('m003','护套绝缘电线','BVV-35','供电局#仓库',80,22.80);insertintostockvalues('m004','护套绝缘电线','BVV-50','供电局#仓库',283,32.00);insertintostockvalues('m005','护套绝缘电线','BVV-70','供电局#仓库',130,40.80);insertintostockvalues('m006','护套绝缘电线','BVV-150','供电局#仓库',46,null);insertintosto
7、ckvalues('m007','架空绝缘电线','10KV-120','供电局#仓库',85,14.08);insertintostockvalues('m009','护套绝缘电线','BVV-16','供电局#仓库',90,null);insertintostockvalues('m011','护套绝缘电线','BVV-95','供电局#仓库',164,null);insertintostockvalues('m012','交联聚乙烯绝缘电线','YJV22-15KV','供电局#仓库',45,719.80);inse
8、rtintostockvalues('m013','户外真空断路器','ZW12-12','供电局#仓库',1,133600.00);插入到out_stockinsertintoout_stockvalues('20100015','m001',2,2010-10-12,'工程部');insertint