【正文】 UPDATA thxxSET dj=9WHERE thh=39。DELETEFROM thxxWHERE thh=39。033339。033339。339。)。,39。,39。(4)選擇SELECT spmFROME kcxxWHERE sph=’022’SELECT spmFROME ghsxxWHERE sph=’222’3退貨信息數(shù)據(jù)操作（1） 插入INSERT INTO thxx(thh,dj,xsh,gysh,thsph)VALUES(39。(3)更新UPDATA kcxxSET dj=1WHERE sph=39。（2） 刪除DELETEFROM kcxxWHERE sph=39。239。1139。02239。,39。,39。,39。UPDATA ghsxxSET dh=999WHERE ghsh=39。DELETEFROM jhxxWHERE jhh=39。陳家橋39。李四39。0239。,39。,39。go 5數(shù)據(jù)操作過程1. 供貨商信息數(shù)據(jù)操作（1）插入INSERTINTO ghsxx(ghsh,sm,fzr,dh,dz)VALUES(39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。go/*==============================================================*//* Table: kcxx *//*==============================================================*/create table kcxx ( sph int not null, spm char(10) null, gysh int null, jhj int null, dj int null, gysm char(10) null, constraint PK_KCXX primary key nonclustered (sph))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。go/*==============================================================*//* Table: jhxx *//*==============================================================*/create table jhxx ( jhh int not null, hj int null, jhsph int null, gysh int null, sl int null, constraint PK_JHXX primary key nonclustered (jhh))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。go/*==============================================================*//* Index: Relationship_11_FK *//*==============================================================*/create index Relationship_11_FK on Relationship_6 (jhh ASC)go/*==============================================================*//* Index: Relationship_12_FK *//*==============================================================*/create index Relationship_12_FK on Relationship_6 (xsj ASC)go/*==============================================================*//* Table: ghsxx *//*==============================================================*/create table ghsxx ( ghsh int not null, sm char(10) null, fzr char(6) null, dh int null, dz char(10) null, constraint PK_GHSXX primary key nonclustered (ghsh))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。go/*==============================================================*//* Index: Relationship_9_FK *//*==============================================================*/create index Relationship_9_FK on Relationship_5 (bh ASC)go/*==============================================================*//* Index: Relationship_10_FK *//*==============================================================*/create index Relationship_10_FK on Relationship_5 (sph ASC)go/*=================================