参考文章：http://www.cnblogs.com/Abel_cn/archive/2008/12/09/1351425.html
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Syste
/***** 检索特定 表名+字段名 *****/
select * from INFORMATION_SCHEMA.COLUMNSwhere TABLE_NAME in ( select name from sysobjects where type = "U")
select * from INFORMATION_SCHEMA
代码如下：
declare @test varchar(max)
set @test=""
IF EXISTS(SELECT iid FROM sort WHERE Parent=0)
begin
select @test=@test+","+CAST(iid AS VARCHAR) from sort WHERE Parent=0 ORDER BY iid
I
