DIV class=guanggao><SPAN id=contentAdv></SPAN></DIV><SPAN class=t18>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN>1)<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">        </SPAN></SPAN>事例数据库表：<BR>企业信息表</DIV>
<P>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; MARGIN-LEFT: 5.4pt; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">表名称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: windowtext 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV>prd_wxt_enterprise_tbl_EnterpriseInfo</DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">数据来源</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV> </DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">存储数据</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV>企业信息表</DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">主键</SPAN><SPAN style="FONT-SIZE: 9pt">/</SPAN><SPAN style="FONT-SIZE: 9pt">外键</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV> </DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=144 colSpan=2>
<DIV><SPAN style="FONT-SIZE: 9pt">字段名称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 135pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=180>
<DIV><SPAN style="FONT-SIZE: 9pt">说明</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=108>
<DIV><SPAN style="FONT-SIZE: 9pt">类型</SPAN><SPAN style="FONT-WEIGHT: normal; FONT-SIZE: 9pt">（精度范围）</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 90pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=120>
<DIV><SPAN style="FONT-SIZE: 9pt">备注</SPAN></DIV></TD></TR>
<TR style="HEIGHT: 19.1pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 19.1pt" vAlign=bottom width=144 colSpan=2>
<DIV>cEnterpriseId</DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 135pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 19.1pt" vAlign=bottom width=180>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">企业</SPAN><SPAN style="FONT-SIZE: 9pt">ID</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 19.1pt" vAlign=bottom width=108>
<DIV>Char(10)</DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 90pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 19.1pt" vAlign=top width=120>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 16.45pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 16.45pt" vAlign=bottom width=144 colSpan=2>
<DIV>sEnterpriseName</DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 135pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 16.45pt" vAlign=bottom width=180>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">企业名称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 16.45pt" vAlign=bottom width=108>
<DIV>Varchar(200)</DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 90pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 16.45pt" vAlign=top width=120>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=bottom width=144 colSpan=2>
<DIV>sShortName</DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 135pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=bottom width=180>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">简称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=bottom width=108>
<DIV>Varchar(50)</DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 90pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=120>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=bottom width=144 colSpan=2>
<DIV>sAddress</DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 135pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=bottom width=180>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">地址</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=bottom width=108>
<DIV>nVarchar(200)</DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 90pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=120>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt; COLOR: red">E_system</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 135pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=180>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt; COLOR: red">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: red">企业所属系统（</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: red">0</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: red">新系统，空或</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: red">1</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: red">为旧系统）</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="COLOR: red">Char(1)</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 90pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=120>
<DIV> </DIV></TD></TR></TBODY></TABLE></P>
<DIV>产品表</DIV>
<P>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; MARGIN-LEFT: 5.4pt; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">表名称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: windowtext 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV><SPAN style="FONT-SIZE: 9pt">Shop_tbl_</SPAN>ProductInfo</DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">数据来源</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV> </DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">存储数据</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV><SPAN style="FONT-SIZE: 9pt">产品表</SPAN></DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 63pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=84>
<DIV><SPAN style="FONT-SIZE: 9pt">主键</SPAN><SPAN style="FONT-SIZE: 9pt">/</SPAN><SPAN style="FONT-SIZE: 9pt">外键</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; BACKGROUND: silver 0% 50%; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 351pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" vAlign=top width=468 colSpan=4>
<DIV> </DIV></TD></TR>
<TR>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=144 colSpan=2>
<DIV><SPAN style="FONT-SIZE: 9pt">字段名称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=168>
<DIV><SPAN style="FONT-SIZE: 9pt">说明</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=108>
<DIV><SPAN style="FONT-SIZE: 9pt">类型</SPAN><SPAN style="FONT-WEIGHT: normal; FONT-SIZE: 9pt">（精度范围）</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid" vAlign=top width=132>
<DIV><SPAN style="FONT-SIZE: 9pt">备注</SPAN></DIV></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">P_Code(PK)</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=168>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">产品</SPAN><SPAN style="FONT-SIZE: 9pt">SKU</SPAN><SPAN style="FONT-SIZE: 9pt">号,即下单号，产品系统编号(p123456789)</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">Char(10)</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=132>
<DIV>not null</DIV></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=144 colSpan=2>
<DIV>EnterpriseId</DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=168>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">企业</SPAN><SPAN style="FONT-SIZE: 9pt">ID</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=108>
<DIV>Char(10)</DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=132>
<DIV>not null</DIV></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">P_Name</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=168>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">产品名称</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">Nvarchar(100)</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 15pt" vAlign=top width=132>
<DIV>not null</DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">P_Price</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=168>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">产品价格（单位元）</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">Money</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=132>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">P_UserPrice</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=168>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">产品会员价（单位元）</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">Money</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=132>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">Remark</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=168>
<DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN style="FONT-SIZE: 9pt">n<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal">          </SPAN></SPAN><SPAN style="FONT-SIZE: 9pt">备注</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left><SPAN style="FONT-SIZE: 9pt">Nvarchar(500)</SPAN></DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=132>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR>
<TR style="HEIGHT: 8.05pt">
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 3pt double; WIDTH: 108pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=144 colSpan=2>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 126pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=168>
<DIV> </DIV></TD>
<TD style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=108>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD>
<TD style="BORDER-RIGHT: 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid; HEIGHT: 8.05pt" vAlign=top width=132>
<DIV style="MARGIN-LEFT: -0.7pt" align=left> </DIV></TD></TR></TBODY></TABLE></P>
<P>2)        要实现的功能：<BR>删除旧企业数据及相关的产品，要求用嵌套存储过程实现<BR>3)        存储过程：包括两个存储过程<BR>a)         存储过程一：根据企业ID，删除该企业及下面的产品：<BR>存储过程代码如下：<BR>/*<BR>功能：删除企业，同时删除关联的表，包括企业表及其关联的产品表数据<BR>创建人： <BR>创建日期：2007-4-10<BR>修改日期：2007-4-10<BR>*/<BR>CREATE PROCEDURE [DeleteEnterprise] <BR>(<BR> @EnterpriseID nvarchar(10)<BR>)<BR>AS<BR>declare @strSQL nvarchar(4000)<BR>--删除企业产品表<BR>select @strSQL = "delete from Shop_tbl_ProductInfo where EnterpriseId='"+@EnterpriseID+"'";<BR>exec(@strSQL)<BR>--删除企业表<BR>select @strSQL = "delete from prd_wxt_enterprise_tbl_EnterpriseInfo where cEnterpriseID='"+@EnterpriseID+"'";<BR>exec(@strSQL)<BR>GO</P>
<P><FONT color=#ff0000></p><p align='center'><b><font color='red'>[1]</font> <a href='http://edu.itbulo.com/200704/113715_2.htm'>[2]</a> <a href='http://edu.itbulo.com/200704/113715_2.htm'>下一页</a> </b></p><script language='javascript' src='http://www.iTbulo.com/gg/200703/79.js'></script></td>
</tr>
</table><!--c-pip文章正文中间240*200--><SPAN id=span_ad3>
<SCRIPT language=JavaScript>
document.write("<script src=\"http://www.iTbulo.com/gg/200703/78.js\"><\/script>");</SCRIPT>
</SPAN>
<SCRIPT>
document.getElementById("contentAdv").innerHTML=document.getElementById("span_ad3").innerHTML;
document.getElementById("span_ad3").innerHTML="";
</SCRIPT>
</td>
<td width="1" valign="top" bgcolor="#A8A8A8"></td>
<td width="173" valign="top" bgcolor="F3F3F3">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="21" align="center" valign="middle" bgcolor="DFDFDF"><strong>文章搜索</strong></td>
</tr>
<tr>
<td height="2" bgcolor="A3A3A3"></td>
</tr>
<form method="Get" name="SearchForm" action="/Search.asp" target="_blank"><TR>
<TD height="40" align=center><input name="Field" type="hidden" id="Field" value="Title"><INPUT name=Keyword id="Keyword" size=16> <INPUT type=submit value=搜索 name=submit onClick="if(this.form.Keyword.value=='') {alert('请输入关键字');return false;}"></TD></TR></FORM>
<tr>
<td height="21" align="center" valign="middle" bgcolor="DFDFDF"><strong>