huntfox的专栏

访问 Microsoft SQL Server 元数据的三种方法 上海微创软件有限公司 肖桂东 适用读者：Microsoft SQL Server 中、高级用户 元数据简介 元数据 (metadata) 最常见的定义为"有关数据的结构数据"，或者再简单一点就是"关于数据的信息"，日常生活中的图例、图书馆目录卡和名片等都可以看作是元数据。在关系型数据库管理系统 (DBMS) 中，元数

ALTER PROCEDURE GetDataBaseInfo9ASselect (case when b.colorder=1 or b.colorder Is null then a.name else end)  as N表名 ,b.name as N字段名 ,(case when C.NAME Is null then else C.NAME end) AS N数

select name from sysobjects where id in(SELECT distinct bb.depid as kkFROM sysobjects JOIN sysdepends bb ON bb.id = sysobjects.idwhere sysobjects.name=存储过程名)--By HuntFox

ALTER PROCEDURE dbo.StoredProcedure1AS select   (case when COLUMNPROPERTY( ss.id,ss.name,IsIdentity)=1 then 1else 0 end) N标识,(case when (SELECT count(*) FROM sysobjects WHERE (name in (SELECT

"东城区|110101","西城区|110102","崇文区|110103","宣武区|110104","朝阳区|110105","丰台区|110106","石景山区|110107","海淀区|110108","门头沟区|110109","房山区|110111","通州区|110112","顺义区|110113","昌平区|110114","大兴区|110115","平谷区|110117","怀柔