管理
create table tmp (name varchar(500),rows int,reserved varchar(500), data varchar(500),index_size varchar(500),unused varchar(500))insert into tmp (name,rows,reserved, data,index_size,unused) exec sp_msforeachTable @Command1="sp_spaceused '?'"--sp_spaceused 't_vehicle'select * from tmp order by [rows] desc drop table tmpdeclare @maxrowcount intdeclare @maxtablename varchar(200)declare @sql nvarchar(2000)declare @tempcount intset @sql = '';set @maxtablename = '';create table #rowcount(counts int,tname varchar(200))declare Tnamecursor cursor for select name from sysobjects where xtype = 'U' and OBJECTPROPERTY(id, N'IsUserTable') = 1declare @name varchar(200);open TnamecursorFETCH NEXT FROM Tnamecursor INTO @nameWHILE @@FETCH_STATUS = 0 BEGIN set @sql = 'select @tempcount = count(*) from '+@name +' insert into #rowcount values (@tempcount,@name)';print @sql exec sp_executesql @sql,N'@tempcount int,@name varchar(200)',@tempcount,@name --print @name+'total count:'+Convert(varchar(200),@tempcount) if(@maxrowcount <@tempcount) begin set @maxrowcount = @tempcount; set @maxtablename = @name; end FETCH NEXT FROM Tnamecursor INTO @name endCLOSE TnamecursorDEALLOCATE Tnamecursorselect * from #rowcount order by counts descdrop table #rowcount 江南七怪＋马玉＋洪七公＋一灯大师＋周伯通（教一个弱智儿童）==郭靖大侠
天下第一王重阳（教七个天资不错的小孩）==全真七子
全真七子×3<郭靖大侠
这就是王重阳盲目扩招的严重后果！！！
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{ string sql = "select id,name,parentid from [product] where isproduct='0' and id<>0"; dt = SqlHelper.ExecuteDataset(sql).Tables[0]; InitTreeAll();
}
}private void InitTreeAll() { TreeNode tmpNd; DataRow[] rows = dt.Select("ParentID=" + "0 and id<>0"); foreach (DataRow dr in rows) { tmpNd = new TreeNode(dr["name"].ToString(), dr["id"].ToString()); Product_tree.Nodes.Add(tmpNd); tmpNd.Expanded = true; DataRow[] rowss = dt.Select("parentid = " + dr["id"].ToString()); foreach (DataRow drr in rowss) { tmpNd.ChildNodes.Add(new TreeNode(drr["name"].ToString(), drr["id"].ToString(),"","UI/productlist.aspx?id="+drr["id"].ToString(),"_blank")); tmpNd.Expanded = true; } } Product_tree.ExpandAll(); }