博客园-yide-最新评论http://www.cnblogs.com/yide/CommentsRSS.aspxzh-cnTue, 20 Mar 2007 02:31:14 GMTTue, 20 Mar 2007 02:31:14 GMTcnblogsre: 用delphi写excel文件http://www.cnblogs.com/yide/archive/2008/10/09/680772.html#1335943shileishileiThu, 09 Oct 2008 06:43:33 GMThttp://www.cnblogs.com/yide/archive/2008/10/09/680772.html#1335943
shilei 2008-10-09 14:43 发表评论
]]>re: 用delphi写excel文件http://www.cnblogs.com/yide/archive/2008/07/08/680772.html#1248741LDCLDCTue, 08 Jul 2008 08:44:59 GMThttp://www.cnblogs.com/yide/archive/2008/07/08/680772.html#1248741http://msdn.microsoft.com/zh-cn/library/microsoft.office.interop.excel.xlcharttype.aspx

LDC 2008-07-08 16:44 发表评论
]]>re: 用delphi写excel文件http://www.cnblogs.com/yide/archive/2008/02/22/680772.html#1077664chelenchelenFri, 22 Feb 2008 06:51:00 GMThttp://www.cnblogs.com/yide/archive/2008/02/22/680772.html#1077664終于找到了一個可以生成Excel圖型的例子, 在此深表感謝!
但有些不明白是:
1.如何知道 xl3DColumnClustered 是立體叢集直條圖;
2.如何知道ChartObjects有哪些屬性.
請問有哪些資料可以參考嗎?
希望不憫賜教.

chelen 2008-02-22 14:51 发表评论
]]>re: Table查詢 不完全相等問題 http://www.cnblogs.com/yide/archive/2006/01/19/315870.html#320135Yin PengYin PengThu, 19 Jan 2006 03:12:00 GMThttp://www.cnblogs.com/yide/archive/2006/01/19/315870.html#320135 FROM (
SELECT key1 AS key3, qty1 AS qty3
FROM table1
UNION
SELECT key2 AS key3, qty2 AS qty3
FROM table2
) A
GROUP BY key3

Yin Peng 2006-01-19 11:12 发表评论
]]>re: 怎樣在查詢結果中加入子序號 ?http://www.cnblogs.com/yide/archive/2006/01/19/316648.html#320119Yin PengYin PengThu, 19 Jan 2006 02:59:00 GMThttp://www.cnblogs.com/yide/archive/2006/01/19/316648.html#320119
下面这一段在SQL Server 2005 Express中试过是可行的。使用了一个临时表。

DECLARE @n int
DECLARE @last nvarchar(10) --定义成与key2相同的类型

SELECT key1, key2, time, 0 AS subseq
INTO #tmptable
FROM testtable
ORDER BY key2

UPDATE #tmptable
SET
@n = CASE WHEN @last = key2 THEN @n+1 ELSE 1 END,
subseq = @n,
@last = key2

SELECT * FROM #tmptable

DROP TABLE #tmptable


Yin Peng 2006-01-19 10:59 发表评论
]]>re: Table查詢 不完全相等問題 http://www.cnblogs.com/yide/archive/2006/01/13/315870.html#316451--------Fri, 13 Jan 2006 00:41:00 GMThttp://www.cnblogs.com/yide/archive/2006/01/13/315870.html#316451
---- 2006-01-13 08:41 发表评论
]]>re: Table查詢 不完全相等問題 http://www.cnblogs.com/yide/archive/2006/01/12/315870.html#315998feiyun0112feiyun0112Thu, 12 Jan 2006 07:15:00 GMThttp://www.cnblogs.com/yide/archive/2006/01/12/315870.html#315998union
select key2 as key 1 , qty2 as qty1 from T2 where key2 not in (select key1 from T1)
union
select key1 , qty1+qty2 as qty1 from T2,T1 where T2.key2=T1key1
order by key1

feiyun0112 2006-01-12 15:15 发表评论
]]>