(SELEct sysdatabases name Maryename ename<span style="color: #0000ff">use<span style="color: #000000"> bond
<span style="color: #008080">--<span style="color: #008080">基金类型表(左用)
<span style="color: #0000ff">if <span style="color: #808080">exists (<span style="color: #0000ff">SELEct <span style="color: #808080">* <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">table<span style="color: #000000"> jjlx
<span style="color: #0000ff">create <span style="color: #0000ff">table<span style="color: #000000"> jjlx
(
id <span style="color: #0000ff">int <span style="color: #0000ff">priMary <span style="color: #0000ff">key <span style="color: #ff00ff">identity(<span style="color: #800000; font-weight: bold">1,<span style="color: #800000; font-weight: bold">1),<span style="color: #008080">--<span style="color: #008080">id
jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50) <span style="color: #808080">not <span style="color: #0000ff">null <span style="color: #008080">--<span style="color: #008080">基金类型
<span style="color: #000000">)
<span style="color: #008080">--<span style="color: #008080">基金类型表增加存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">SELEct <span style="color: #808080"> <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_add<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_add
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_add
<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">)
<span style="color: #0000ff">as
<span style="color: #0000ff">insert <span style="color: #0000ff">into jjlx <span style="color: #0000ff">values (<span style="color: #008000">@jjlx<span style="color: #000000">)
<span style="color: #0000ff">go
<span style="color: #008080">--<span style="color: #008080">基金类型表查询存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">
SELEct <span style="color: #808080"> <span style="color: #0000ff">from sy
s.ob
jects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">p_jjlx<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> p_jjlx
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> p_jjlx
<span style="color: #0000ff">as
<span style="color: #0000ff">
SELEct <span style="color: #808080">
<span style="color: #0000ff">from<span style="color: #000000"> jjlx
<span style="color: #0000ff">go
<span style="color: #008080">--<span style="color: #008080">基金类型表修改存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">SELEct <span style="color: #808080"> <span style="color: #0000ff">from sy
s.ob
jects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_gai<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_gai
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_gai
<span style="color: #008000">@id <span style="color: #0000ff">int<span style="color: #000000">,<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">)
<span style="color: #0000ff">as
<span style="color: #0000ff">
updatE jjlx <span style="color: #0000ff">SET jjlx<span style="color: #808080">=<span style="color: #008000">@jjlx <span style="color: #0000ff">where id<span style="color: #808080">=<span style="color: #008000">@id
<span style="color: #0000ff">go
<span style="color: #008080">--<span style="color: #008080">基金类型表删除存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">
SELEct <span style="color: #808080">* <span style="color: #0000ff">from sy
s.ob
jects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_
delete<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_
delete
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_
delete
<span style="color: #008000">@id <span style="color: #0000ff">int<span style="color: #000000">,<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">)
<span style="color: #0000ff">as
<span style="color: #0000ff">
delete <span style="color: #0000ff">from jjlx <span style="color: #0000ff">where id<span style="color: #808080">=<span style="color: #008000">@id <span style="color: #808080">and jjlx<span style="color: #808080">=<span style="color: #008000">@jjlx
<span style="color: #0000ff">go