博客园-倚栏望海集-最新评论http://www.cnblogs.com/1landonsea/CommentsRSS.aspx知其然, 知其所以然, 求其所源, 后知其所踪，为善zh-cnWed, 20 Jan 2010 08:25:31 GMTWed, 20 Jan 2010 08:25:31 GMTcnblogsRe:The implementation of IDisposable Pattern of System.Net.NetworkInformation.Ping may be wronghttp://www.cnblogs.com/1landonsea/archive/2009/10/23/1588404.html#1679915Aaron@cnblogsAaron@cnblogsFri, 23 Oct 2009 15:46:10 GMThttp://www.cnblogs.com/1landonsea/archive/2009/10/23/1588404.html#1679915
Aaron@cnblogs 2009-10-23 23:46 发表评论
]]>Re:The implementation of IDisposable Pattern of System.Net.NetworkInformation.Ping may be wronghttp://www.cnblogs.com/1landonsea/archive/2009/10/23/1588404.html#1679650anonymous_1anonymous_1Fri, 23 Oct 2009 09:26:12 GMThttp://www.cnblogs.com/1landonsea/archive/2009/10/23/1588404.html#1679650
anonymous_1 2009-10-23 17:26 发表评论
]]>re: 春节广州西关行http://www.cnblogs.com/1landonsea/archive/2005/06/07/108032.html#169863JayJayTue, 07 Jun 2005 15:43:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/06/07/108032.html#169863
Jay 2005-06-07 23:43 发表评论
]]>re: 春节广州西关行http://www.cnblogs.com/1landonsea/archive/2005/06/07/108032.html#169862JayJayTue, 07 Jun 2005 15:42:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/06/07/108032.html#169862
Jay 2005-06-07 23:42 发表评论
]]>re: 春节广州西关行http://www.cnblogs.com/1landonsea/archive/2005/05/16/108032.html#156555cheerlycheerlyMon, 16 May 2005 10:17:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/05/16/108032.html#156555
cheerly 2005-05-16 18:17 发表评论
]]>re: 得到PostgreSQL 数据库表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2005/03/23/81358.html#124343kngihtkngihtWed, 23 Mar 2005 12:25:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/03/23/81358.html#124343
kngiht 2005-03-23 20:25 发表评论
]]>re: 春节广州西关行http://www.cnblogs.com/1landonsea/archive/2005/03/07/108032.html#114219依栏望海集依栏望海集Mon, 07 Mar 2005 02:41:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/03/07/108032.html#114219
依栏望海集 2005-03-07 10:41 发表评论
]]>re: 春节广州西关行http://www.cnblogs.com/1landonsea/archive/2005/03/07/108032.html#114203清音 清音 Mon, 07 Mar 2005 02:22:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/03/07/108032.html#114203
清音 2005-03-07 10:22 发表评论
]]>re: 你会重抛异常(re-throw Exception)不？http://www.cnblogs.com/1landonsea/archive/2005/01/15/92150.html#92308CsOverCsOverSat, 15 Jan 2005 06:30:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/01/15/92150.html#92308
CsOver 2005-01-15 14:30 发表评论
]]>re: 读及其它http://www.cnblogs.com/1landonsea/archive/2005/01/07/46172.html#87919widerflowerswiderflowersFri, 07 Jan 2005 02:54:00 GMThttp://www.cnblogs.com/1landonsea/archive/2005/01/07/46172.html#87919给你弄的，满眼中国字我都茫然咯

widerflowers 2005-01-07 10:54 发表评论
]]>re: 想起K.I.S.S.http://www.cnblogs.com/1landonsea/archive/2004/12/31/50268.html#84532小牛哥小牛哥Thu, 30 Dec 2004 16:59:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/31/50268.html#84532
小牛哥 2004-12-31 00:59 发表评论
]]>re: npgsql 0.7beta3 的一个Bug （submitted）http://www.cnblogs.com/1landonsea/archive/2004/12/30/84153.html#84191依栏望海集依栏望海集Thu, 30 Dec 2004 03:51:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/30/84153.html#84191
依栏望海集 2004-12-30 11:51 发表评论
]]>re: npgsql 0.7beta3 的一个Bug （submitted）http://www.cnblogs.com/1landonsea/archive/2004/12/30/84153.html#84172dudududuThu, 30 Dec 2004 03:34:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/30/84153.html#84172
dudu 2004-12-30 11:34 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/28/81358.html#82861依栏望海集依栏望海集Tue, 28 Dec 2004 01:25:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/28/81358.html#82861用这么多函数是比较省事，但效率有点低。当然，一般得到信息都是在配置中用，效率可以忽略。

依栏望海集 2004-12-28 09:25 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/28/81358.html#82859依栏望海集依栏望海集Tue, 28 Dec 2004 01:23:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/28/81358.html#82859 (case when a.colorder=1 then d.name else '' end) N'表名',
a.colorder N'字段序号',
a.name N'字段名',
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) N'标识',
(case when (SELECT count(*)
FROM sysobjects
WHERE (name in
(SELECT name
FROM sysindexes
WHERE (id = a.id) AND (indid in
(SELECT indid
FROM sysindexkeys
WHERE (id = a.id) AND (colid in
(SELECT colid
FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = 'PK'))>0 then '√' else '' end) N'主键',
b.name N'类型',
a.length N'占用字节数',
COLUMNPROPERTY(a.id,a.name,'PRECISION') as N'长度',
isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as N'小数位数',
(case when a.isnullable=1 then '√'else '' end) N'允许空',
isnull(e.text,'') N'默认值',
isnull(g.[value],'') AS N'字段说明'
--into ##tx

FROM syscolumns a left join systypes b
on a.xtype=b.xusertype
inner join sysobjects d
on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
left join syscomments e
on a.cdefault=e.id
left join sysproperties g
on a.id=g.id AND a.colid = g.smallid
order by object_name(a.id),a.colorder

依栏望海集 2004-12-28 09:23 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/27/81358.html#82347依栏望海集依栏望海集Mon, 27 Dec 2004 01:47:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/27/81358.html#82347
依栏望海集 2004-12-27 09:47 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81544cookieswolfcookieswolfFri, 24 Dec 2004 07:25:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81544select lower(a.name) as tablename,rtrim(b.name) as colname,case when h.id is not null then 'PK' else '' end as primarykey
,type_name(b.xusertype) + case when b.colstat & 1 = 1 then '[ID(' + convert(varchar,ident_seed(a.name)) + ',' + convert(varchar,ident_incr(a.name)) + ')]' else '' end as type
,b.length,case b.isnullable when 0 then 'N' else 'Y' end as [isnull],isnull(e.text,'') as [default],convert(varchar(30),isnull(c.value,rtrim(b.name))) as descript,'1'
from sysobjects a,syscolumns b
left outer join sysproperties c on b.id = c.id and b.colid = c.smallid
left outer join syscomments e on b.cdefault = e.id
left outer join (select g.id,g.colid from sysindexes f,sysindexkeys g where f.id = g.id and f.indid = g.indid and f.indid > 0 and f.indid < 255 and (f.status & 2048)<>0) h on b.id = h.id and b.colid = h.colid
where a.id = b.id and a.xtype='U' and a.id = object_id(a.name)

cookieswolf 2004-12-24 15:25 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81518依栏望海集依栏望海集Fri, 24 Dec 2004 06:47:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81518
依栏望海集 2004-12-24 14:47 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81497春鱼春鱼Fri, 24 Dec 2004 06:12:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81497
扩展属性包括关于表、列、和其他系统对象的信息。例如对列的注释。

以下是列出关于表的列(字段)注释的简单实例:

CREATE table T1 (id int , name char (20))
EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo, 'table', 'T1', 'column', id
EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo, 'table', 'T1', 'column', name

SELECT *
FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'T1', 'column', default)

春鱼 2004-12-24 14:12 发表评论
]]>re: 虫子加油！:Phttp://www.cnblogs.com/1landonsea/archive/2004/12/24/81457.html#81458依栏望海集依栏望海集Fri, 24 Dec 2004 05:27:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/24/81457.html#81458
依栏望海集 2004-12-24 13:27 发表评论
]]>re: 得到PostgreSQL 表字段的部分信息（Name,Type,Len,PK,AutoIncrease,AllowNullable）http://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81441progameprogameFri, 24 Dec 2004 05:12:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/12/24/81358.html#81441"select a.name,a.id, case when (b.nullable = 'yes') then 1 else 0 end as nullable,"
+ " b.type,case when (c.name is null) then 0 else 1 end as pk from "
+ " ( select name, CASE WHEN (colstat & 1 = 1) then 1 else 0 end as ID "
+ " from syscolumns where id = object_id('{0}') ) a "
+ " inner join ( select COLUMN_NAME as name,IS_NULLABLE as nullable,DATA_TYPE as type "
+ " from information_schema.columns where table_name='{0}' ) b on a.name = b.name "
+ " left join ( select index_col('{0}',i.indid,c.colid) as name "
+ " from sysindexes i ,syscolumns c "
+ " where i.id = object_id('{0}') and "
+ " ( i.status & 0x800) = 0x800 and c.id = i.id and index_col('{0}',i.indid,c.colid) is not null) "
+ " c on a.name = c.name"

progame 2004-12-24 13:12 发表评论
]]>re: Com+和数据库访问对象的一些问题的研究（2002年12月10日）http://www.cnblogs.com/1landonsea/archive/2004/10/09/50272.html#50329ccBoyccBoySat, 09 Oct 2004 13:54:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/10/09/50272.html#50329
Improving .NET Application Performance and Scalability
是个不错的资源,必读吧!!




ccBoy 2004-10-09 21:54 发表评论
]]>re: Com+和数据库访问对象的一些问题的研究（2002年12月10日）http://www.cnblogs.com/1landonsea/archive/2004/10/09/50272.html#50327Johnny HuJohnny HuSat, 09 Oct 2004 13:43:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/10/09/50272.html#50327
Johnny Hu 2004-10-09 21:43 发表评论
]]>re: 关于编程语言的问答http://www.cnblogs.com/1landonsea/archive/2004/09/23/45847.html#46012dudududuThu, 23 Sep 2004 12:32:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/09/23/45847.html#46012

dudu 2004-09-23 20:32 发表评论
]]>re: 关于编程语言的问答http://www.cnblogs.com/1landonsea/archive/2004/09/23/45847.html#45966问题男问题男Thu, 23 Sep 2004 09:58:00 GMThttp://www.cnblogs.com/1landonsea/archive/2004/09/23/45847.html#45966
“如当年微观物理学的出现击碎了宏观物理学家们以一个理论描述宇宙的梦想”，没有击碎吧，但着实加大了难度

和谐统一是永恒的自然规律

问题男 2004-09-23 17:58 发表评论
]]>