可我在sql查询分析器中运行SELECT 字段名=article.name,字段说明=isnull(g.[value],'') FROM syscolumns article left join sysproperties g on article.id=g.id and article.colid=g.smallid where article.id=object_id('article') and article.name in('title','sourcetype')的确是返回那些信息阿
查询脚本是 SELECT 字段名=article.name,字段说明=isnull(g.[value],'') FROM syscolumns article left join sysproperties g on article.id=g.id and article.colid=g.smallid where article.id=object_id('article') and article.name in('title','sourcetype')
FROM syscolumns article
left join sysproperties g on article.id=g.id and article.colid=g.smallid
where article.id=object_id('article')
and article.name in('title','sourcetype')的确是返回那些信息阿
CREATE TABLE [article] (
[articleid] [int] IDENTITY (1, 1) NOT NULL ,
[title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sourcetype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[source] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[keyword] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[contentsize] [int] NULL CONSTRAINT [DF__article__content__440B1D61] DEFAULT (0),
[dateandtime] [datetime] NULL ,
[adminid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hits] [int] NULL CONSTRAINT [DF__article__hits__44FF419A] DEFAULT (0),
[classname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[l2classname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[userdeem] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ubbmode] [int] NOT NULL CONSTRAINT [DF__article__ubbmode__45F365D3] DEFAULT (1),
[best] [int] NOT NULL CONSTRAINT [DF__article__best__46E78A0C] DEFAULT (0),
[del] [int] NOT NULL CONSTRAINT [DF__article__del__47DBAE45] DEFAULT (0),
[editor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[editorid] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[editoract] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[oldimgname] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[imgname] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[oldothername] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[othername] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[locktopic] [int] NOT NULL CONSTRAINT [DF__article__locktop__48CFD27E] DEFAULT (0),
[delclass] [int] NOT NULL CONSTRAINT [DF__article__delclas__49C3F6B7] DEFAULT (0),
[imgnews] [int] NOT NULL CONSTRAINT [DF__article__imgnews__4AB81AF0] DEFAULT (0),
[recomment] [int] NOT NULL CONSTRAINT [DF__article__recomme__4BAC3F29] DEFAULT (1),
[commentnum] [int] NULL CONSTRAINT [DF__article__comment__4CA06362] DEFAULT (0),
[subhead] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[ThumbnailSNum] [int] NOT NULL CONSTRAINT [DF__article__Thumbna__4D94879B] DEFAULT ((-1)),
[ThumbnailFN] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Dayhits] [int] NOT NULL CONSTRAINT [DF__article__Dayhits__4E88ABD4] DEFAULT (0),
[WeekHits] [int] NOT NULL CONSTRAINT [DF__article__WeekHit__4F7CD00D] DEFAULT (0),
[MonthHits] [int] NOT NULL CONSTRAINT [DF__article__MonthHi__5070F446] DEFAULT (0),
[YesterdayHits] [int] NOT NULL CONSTRAINT [DF__article__Yesterd__5165187F] DEFAULT (0),
[BeforeYesterdayHits] [int] NOT NULL CONSTRAINT [DF__article__BeforeY__52593CB8] DEFAULT (0),
[LastWeekHits] [int] NOT NULL CONSTRAINT [DF__article__LastWee__534D60F1] DEFAULT (0),
[UltimoHits] [int] NOT NULL CONSTRAINT [DF__article__UltimoH__5441852A] DEFAULT (0),
CONSTRAINT [aaaaaarticle_PK] PRIMARY KEY NONCLUSTERED
(
[articleid]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SELECT 字段名=article.name,字段说明=isnull(g.[value],'')
FROM syscolumns article
left join sysproperties g on article.id=g.id and article.colid=g.smallid
where article.id=object_id('article')
and article.name in('title','sourcetype')