<!--include object info template file for expansion-->
<HTML>
<!--REPORT HEADER-->
<FONT FACE="ARIAL" SIZE=2>
<TABLE WIDTH=100%>
<TR>
<TD BGCOLOR=#110000></FONT></TD>
</TR>
</TABLE>
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
<TD BGCOLOR=#ccccff><B><FONT FACE="ARIAL" SIZE=5><A NAME="Tabledbo.dtproperties">dbo.dtproperties</A></FONT></B></TR>
</TABLE>
<!--COMMENT SECTION-->
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=100><B><FONT FACE="ARIAL" SIZE=2>Object Type</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>Table</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=100><B><FONT FACE="ARIAL" SIZE=2>Datasource</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>XUCHUNBO ( SQL Server 08.00.2039 )</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=100><B><FONT FACE="ARIAL" SIZE=2>Login</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>sa</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=100><B><FONT FACE="ARIAL" SIZE=2>Database</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>rddb</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=100><B><FONT FACE="ARIAL" SIZE=2>Report Date</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>2007-10-19 09:06:48.421</FONT></TD>
</TR>
</TABLE>
</HTML>
<P>
<!--include table column template file for expansion-->
<HTML>
<!--COLUMNS SECTION-->
<P>
</TABLE>
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
<TR>
<TD BGCOLOR=#ccccff><FONT FACE="ARIAL" SIZE=4>Columns</FONT></TD>
</TR>
</TABLE>
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
<TR>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=240><B><FONT FACE="ARIAL" SIZE=2>Name</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=160><B><FONT FACE="ARIAL" SIZE=2>Datatype</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=80><B><FONT FACE="ARIAL" SIZE=2>Null</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=120><B><FONT FACE="ARIAL" SIZE=2>Default</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=200><B><FONT FACE="ARIAL" SIZE=2>Default Binding</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=200><B><FONT FACE="ARIAL" SIZE=2>Rule Binding</FONT></B></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>id</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>int</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>No</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>objectid</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>int</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>Yes</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>property</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>varchar(64)</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>No</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>value</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>varchar(255)</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>Yes</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>uvalue</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>nvarchar(255)</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>Yes</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>lvalue</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>image</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>Yes</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>version</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>int</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>No</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0</FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2></FONT></TD>
</TR>
</TABLE>
</HTML>
<!--include TableColumn info template file for expansion-->
<P>
<HTML>
<!--CONSTRAINTS SECTION-->
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
<TR>
<TD BGCOLOR=#ccccff><FONT FACE="ARIAL" SIZE=4>Constraints</FONT></TD>
</TR>
</TABLE>
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
<TR>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=240><B><FONT FACE="ARIAL" SIZE=2>Name</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=80><B><FONT FACE="ARIAL" SIZE=2>Type</FONT></B></TD>
<TD BGCOLOR=LEMONCHIFFON ALIGN=CENTER VALIGN=top WIDTH=400><B><FONT FACE="ARIAL" SIZE=2>Constraint</FONT></B></TD>
</TR>
<TR>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>pk_dtproperties</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>PRIMARY KEY</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>id, property</FONT></B></TD>
</TR>
</TABLE>
</HTML>
<!--Segment-->
<P>
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
<TR>
<TD BGCOLOR=#ccccff><FONT FACE="ARIAL" SIZE=4>Storage</FONT></TD>
</TR>
</TABLE>
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=200><B><FONT FACE="ARIAL" SIZE=2>Filegroup</FONT></B></TD>
<TD VALIGN=top WIDTH=200><FONT FACE="ARIAL" SIZE=2>PRIMARY</FONT></TD>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=200><B><FONT FACE="ARIAL" SIZE=2>Text Image Filegroup</FONT></B></TD>
<TD VALIGN=top WIDTH=200><FONT FACE="ARIAL" SIZE=2>PRIMARY</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=200><B><FONT FACE="ARIAL" SIZE=2>Number of Rows</FONT></B></TD>
<TD VALIGN=top WIDTH=200><FONT FACE="ARIAL" SIZE=2>0</FONT></TD>
</TR>
</TABLE>
<!--STORAGE SECTION-->
<P>
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
<TR>
<TD BGCOLOR=#ccccff ALIGN=CENTER WIDTH=50%><FONT FACE="ARIAL" SIZE=4>Table Usage (MB)</FONT></TD>
<TD BGCOLOR=#ccccff ALIGN=CENTER WIDTH=50%><FONT FACE="ARIAL" SIZE=4>Distribution of Table Space</FONT></TD>
</TR>
</TABLE>
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=150><B><FONT FACE="ARIAL" SIZE=2>Data</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0.00</FONT></TD>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=150><B><FONT FACE="ARIAL" SIZE=2>Data</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0.00 %</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=150><B><FONT FACE="ARIAL" SIZE=2>Indexes</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0.00</FONT></TD>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=150><B><FONT FACE="ARIAL" SIZE=2>Indexes</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0.00 %</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=150><B><FONT FACE="ARIAL" SIZE=2>Unused</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0.00</FONT></TD>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WIDTH=150><B><FONT FACE="ARIAL" SIZE=2>Unused</FONT></B></TD>
<TD VALIGN=top><FONT FACE="ARIAL" SIZE=2>0.00 %</FONT></TD>
</TR>
<TR>
<TD BGCOLOR=LEMONCHIFFON VALIGN=top WID
sql2000高级教程
需积分: 4 90 浏览量
2008-07-08
15:16:08
上传
评论
收藏 168KB RAR 举报
sql高级教程.rar （12个子文件） 
sql高级教程 
trigger_sqlserverCONTENT.htm 185KB trigger_sqlserverTOC.htm 7KB SQL Server Table.htm 211B SQL Server RDDB ViewsTOC.htm 7KB trigger_sqlserver.htm 215B SQL Server RDDB ViewsCONTENT.htm 548KB procedureTOC.htm 78KB SQL Server TableCONTENT.htm 3.08MB procedure.htm 201B procedureCONTENT.htm 2.61MB SQL Server TableTOC.htm 41KB SQL Server RDDB Views.htm 220B资源评论
