gyi
gsha
gbia
haovarchar50setgo
gyi
gsha
gbia
hao插入成功pri
tgo
gyi
gsha
gbia
hao
2、删除会员触发器setANSI_NULLSON
13
fsetQUOTED_IDENTIFIERONgocreateTRIGGERhuiyua
bia
haoONdbo会员信息表AFTERDELETEASselecthuiyua
bia
haoashuiyua
bia
haoxi
gmi
gxi
gbiefromdeleted
五、创建存储过程创建存储过程1、插入供应商信息存储过程
CREATEProcedureGYSgo
gyi
gsha
gbia
haotelvarchar50
14
varchar50varchar50
go
gyi
gsha
gmi
gche
g
fyi
ha
gzha
ghaoAS
varchar50
INSERTINTO供应商信息go
gyi
gsha
gbia
haogo
gyi
gsha
gmi
gche
gtelyi
ha
gzha
ghaoVALUESgo
gyi
gsha
gbia
haogo
gyi
gsha
gmi
gche
gtelyi
ha
gzha
ghao
2、删除会员信息存储过程
CREATEProceduredeletehuiyua
huiyua
bia
haovarchar50ASDeleteFrom会员信息Wherehuiyua
bia
haohuiyua
bia
hao
3、修改销售数量存储过程
15
fCREATEPROCEDURExsslASUPDATE销售出货信息SETxiaoshoushulia
gxiaoshoushulia
g2GO
4、修改存储过程名
EXECsp_re
ameGYSgysGO
16
f六、关系图
七、创建数据维护计划创建数据维护计划
17
f18
fr