vb数据库存销管理系统

  • i7_388268
    了解作者
  • 487.9KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-06-14 13:06
    上传日期
课程设计 要附加数据库文件 同时将计算机名改为lz-edf8506ff89f
vb数据库存销管理系统.rar
  • 存销管理系统
  • bussiness_Log.LDF
    1MB
  • typeadd.frm
    9.5KB
  • updategoods.frm
    11.5KB
  • saleadd.frm
    7.2KB
  • Form1.frm
    5.3KB
  • buyselect.frm
    6.7KB
  • MSSCCPRJ.SCC
    193B
  • main.frm
    17.2KB
  • bussiness_Data.MDF
    1.4MB
  • updategoods.frx
    21B
  • 系统脚本.doc
    72.5KB
  • spoilageadd.frm
    8KB
  • supplieradd.frx
    21B
  • 系统脚本.sql
    39.7KB
  • 商品管理.PDM
    4.5KB
  • buyadd.frm
    7.2KB
  • saleupdate.frm
    14KB
  • typeadd.frx
    21B
  • supplierscan.frx
    21B
  • saleselect.frm
    6.7KB
  • spoilageselect.frm
    9.9KB
  • scangoods.frm
    7.4KB
  • supplieradd.frm
    10.3KB
  • buysale_Log.LDF
    1MB
  • 商品管理.exe
    172KB
  • bysale.txt
    146B
  • 商品管理.vbw
    1012B
  • 商品管理.vbp
    1.4KB
  • supplierscan.frm
    4.5KB
  • buyupdate.frm
    14KB
  • buyupdate.frx
    21B
  • useradd.frm
    5.5KB
  • bysale.sql
    1KB
  • saleupdate.frx
    21B
  • userupdate.frx
    21B
  • userupdate.frm
    10.8KB
  • goodsadd.frm
    9.3KB
  • buysale_Data.MDF
    1.1MB
  • spoilageupdate.frx
    21B
  • spoilageupdate.frm
    13.8KB
内容介绍
<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/1057540/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/1057540/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_ _0"></span> <span class="_ _0"> </span>exists<span class="_ _0"> </span> <span class="_ _0"> </span>(select<span class="_ _0"> </span> <span class="_ _0"> </span>*<span class="_ _0"> </span> <span class="_ _1"> </span>from<span class="_ _0"></span> <span class="_ _0"> </span>dbo.sysobjects<span class="_ _0"></span> <span class="_ _0"> </span>where<span class="_ _0"> </span> <span class="_ _0"> </span>id<span class="_ _0"> </span> <span class="_ _0"> </span>=<span class="_ _0"> </span> <span class="_ _1"> </span>object_id(N'[dbo].[FK_spoilage_buy]')<span class="_ _0"></span> <span class="_ _0"></span>and</div><div class="t m0 x1 h3 y3 ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsForeignKey') = 1)</div><div class="t m0 x1 h3 y4 ff1 fs0 fc0 sc0 ls0 ws0">AL<span class="_ _3"></span>TER T<span class="_ _3"></span>ABLE [dbo].[spoilage] DROP<span class="_ _2"></span> CONSTRAINT FK_spoilage_buy</div><div class="t m0 x1 h3 y5 ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 y6 ff1 fs0 fc0 sc0 ls0 ws0">if <span class="_ _4"></span>exists (select<span class="_ _4"></span> * <span class="_ _4"></span>from dbo.sysobjects<span class="_ _4"></span> where <span class="_ _4"></span>id =<span class="_ _4"></span> object_id(N'[dbo].[FK_goods_goodstype1]') and</div><div class="t m0 x1 h3 y7 ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsForeignKey') = 1)</div><div class="t m0 x1 h3 y8 ff1 fs0 fc0 sc0 ls0 ws0">AL<span class="_ _3"></span>TER T<span class="_ _3"></span>ABLE [dbo].[goods] DROP<span class="_ _2"></span> CONSTRAINT FK_goods_goodstype1</div><div class="t m0 x1 h3 y9 ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 ya ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_ _5"></span> <span class="_ _5"></span>exists<span class="_ _4"></span> <span class="_ _5"></span>(select<span class="_ _5"></span> <span class="_ _5"></span>*<span class="_ _5"></span> <span class="_ _5"></span>from<span class="_ _5"></span> <span class="_ _5"></span>dbo.sysobjects<span class="_ _4"></span> <span class="_ _5"></span>where<span class="_ _5"></span> <span class="_ _5"></span>id<span class="_ _5"></span> <span class="_ _5"></span>=<span class="_ _5"></span> <span class="_ _5"></span>object_id(N'[dbo].[FK_goods_supplier1]')<span class="_ _4"></span> <span class="_ _5"></span>and</div><div class="t m0 x1 h3 yb ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsForeignKey') = 1)</div><div class="t m0 x1 h3 yc ff1 fs0 fc0 sc0 ls0 ws0">AL<span class="_ _3"></span>TER T<span class="_ _3"></span>ABLE [dbo].[goods] DROP<span class="_ _2"></span> CONSTRAINT FK_goods_supplier1</div><div class="t m0 x1 h3 yd ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 ye ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_ _0"> </span> <span class="_ _1"> </span>e<span class="_ _4"></span>xists<span class="_ _0"> </span> <span class="_ _1"> </span>(select<span class="_ _1"> </span> <span class="_ _1"> </span>*<span class="_ _1"> </span> <span class="_ _1"> </span>from<span class="_ _0"> </span> <span class="_ _1"> </span>dbo<span class="_ _4"></span>.sysobjects<span class="_ _0"> </span> <span class="_ _1"> </span>where<span class="_ _1"> </span> <span class="_ _1"> </span>id<span class="_ _1"> </span> <span class="_ _1"> </span>=<span class="_ _0"> </span> <span class="_ _1"> </span>object_id(N'[dbo].[FK_sale_goods1]')<span class="_ _1"> </span> <span class="_ _1"> </span>and</div><div class="t m0 x1 h3 yf ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsForeignKey') = 1)</div><div class="t m0 x1 h3 y10 ff1 fs0 fc0 sc0 ls0 ws0">AL<span class="_ _3"></span>TER T<span class="_ _3"></span>ABLE [dbo].[sale] DROP<span class="_ _6"></span> CONSTRAINT <span class="_ _6"></span>FK_sale_goods1</div><div class="t m0 x1 h3 y11 ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 y12 ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_ _4"></span> <span class="_ _5"></span>exists<span class="_ _5"></span> <span class="_ _5"></span>(select<span class="_ _5"></span> <span class="_ _4"></span>*<span class="_ _5"></span> <span class="_ _5"></span>from<span class="_ _4"></span> <span class="_ _5"></span>dbo.sysobjects<span class="_ _5"></span> <span class="_ _5"></span>where<span class="_ _4"></span> <span class="_ _5"></span>id<span class="_ _5"></span> <span class="_ _5"></span>=<span class="_ _4"></span> <span class="_ _5"></span>object_id(N'[dbo].[FK_spoilage_goods2]')<span class="_ _5"></span> <span class="_ _4"></span>and</div><div class="t m0 x1 h3 y13 ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsForeignKey') = 1)</div><div class="t m0 x1 h3 y14 ff1 fs0 fc0 sc0 ls0 ws0">AL<span class="_ _3"></span>TER T<span class="_ _3"></span>ABLE [dbo].[spoilage] DROP<span class="_ _2"></span> CONSTRAINT FK_spoilage_goods2</div><div class="t m0 x1 h3 y15 ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 y16 ff1 fs0 fc0 sc0 ls0 ws0">/****** Object: T<span class="_ _2"></span>rigger dbo.buyaddnew Script Date: 2007-12-23 17:45:02 ******/</div><div class="t m0 x1 h3 y17 ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_"> </span> <span class="_"> </span>exists<span class="_ _7"> </span> <span class="_"> </span>(select<span class="_"> </span> <span class="_"> </span>*<span class="_ _7"> </span> <span class="_"> </span>from<span class="_"> </span> <span class="_ _7"> </span>dbo.sysobjects<span class="_"> </span> <span class="_"> </span>w<span class="_ _2"></span>h<span class="_ _4"></span>ere<span class="_"> </span> <span class="_"> </span>id<span class="_"> </span> <span class="_"> </span>=<span class="_ _7"> </span> <span class="_"> </span>obje<span class="_ _6"></span>ct_id(N'[dbo].[buyaddnew]')<span class="_"> </span> <span class="_"> </span>and</div><div class="t m0 x1 h3 y18 ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsT<span class="_ _2"></span>rigger') = 1)</div><div class="t m0 x1 h3 y19 ff1 fs0 fc0 sc0 ls0 ws0">drop trigger [dbo].[buyaddnew]</div><div class="t m0 x1 h3 y1a ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 y1b ff1 fs0 fc0 sc0 ls0 ws0">/****** Object: T<span class="_ _2"></span>rigger dbo.updatebuy Script Date: 2007-12-23 17:45:02 ******/</div><div class="t m0 x1 h3 y1c ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_"> </span> <span class="_ _8"> </span>exists<span class="_"> </span> <span class="_ _8"> </span>(select<span class="_"> </span> <span class="_ _8"> </span>*<span class="_"> </span> <span class="_ _8"> </span>from<span class="_"> </span> <span class="_ _8"> </span>dbo.sysobjects<span class="_"> </span> <span class="_"> </span>where<span class="_ _8"> </span> <span class="_"> </span>id<span class="_ _8"> </span> <span class="_"> </span>=<span class="_ _8"> </span> <span class="_"> </span>object_id(N'[dbo].[updatebuy]')<span class="_"> </span> <span class="_ _8"> </span>and</div><div class="t m0 x1 h3 y1d ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsT<span class="_ _2"></span>rigger') = 1)</div><div class="t m0 x1 h3 y1e ff1 fs0 fc0 sc0 ls0 ws0">drop trigger [dbo].[updatebuy]</div><div class="t m0 x1 h3 y1f ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 y20 ff1 fs0 fc0 sc0 ls0 ws0">/****** Object: T<span class="_ _2"></span>rigger dbo.salegoods Script Date: 2007-12-23 17:45:02 ******/</div><div class="t m0 x1 h3 y21 ff1 fs0 fc0 sc0 ls0 ws0">if<span class="_ _8"> </span> <span class="_ _8"> </span>exists<span class="_ _8"> </span> <span class="_"> </span>(select<span class="_ _8"> </span> <span class="_ _8"> </span>*<span class="_ _8"> </span> <span class="_ _8"> </span>from<span class="_ _8"> </span> <span class="_ _8"> </span>dbo.sysobjects<span class="_ _8"> </span> <span class="_ _8"> </span>where<span class="_"> </span> <span class="_ _8"> </span>id<span class="_ _8"> </span> <span class="_ _8"> </span>=<span class="_ _8"> </span> <span class="_ _8"> </span>object_id(N'[dbo].[salegoods]')<span class="_ _8"> </span> <span class="_"> </span>a<span class="_ _4"></span>nd</div><div class="t m0 x1 h3 y22 ff1 fs0 fc0 sc0 ls0 ws0">OBJECTPROPER<span class="_ _2"></span>TY(id, N'IsT<span class="_ _2"></span>rigger') = 1)</div><div class="t m0 x1 h3 y23 ff1 fs0 fc0 sc0 ls0 ws0">drop trigger [dbo].[salegoods]</div><div class="t m0 x1 h3 y24 ff1 fs0 fc0 sc0 ls0 ws0">GO</div><div class="t m0 x1 h3 y25 ff1 fs0 fc0 sc0 ls0 ws0">/****** Object: T<span class="_ _2"></span>rigger dbo.updatesale Script Date: 2007-12-23 17:45:02 ******/</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div></body></html>
评论
    相关推荐
    • 数据库
      数据库
    • 数据库
      数据库 信使
    • 数据库
      数据库
    • 数据库数据库
      数据库数据库
    • 数据库
      数据库
    • 数据库
      数据库
    • 数据库 热备
      数据库自动切换,A>B>C>>A>B>C... 如果加上数据库复制,就是完整的数据库热备了。 数据库复制请参考数据库文档
    • 数据库数据库数据库
      数据库课件 东北大学 软件学院 数据库课件 东北大学 软件学院
    • 数据库设计
      本书是一本介绍数据库设计技术的著作,数据库设计是开发一个好的数据库应用系统的基础,本书运用大量实例对数据库设计过程中所涉及到的技术和知识进行了详细的介绍。本书的内容包括:数据库的基本原理、常用的数据库...
    • 数据库
      数据库