Adding .FLV MIME Type in IIS

.FLV files are already the best method for publishing video on the web, and are sure to become even better with the new enhancements in Flash 8. When serving .flv files off of a Windows Server 2003 (or any other Windows server I would imagine) requires setting up the MIME type on the server first (it isn’t one of the native MIME types on MS servers).

阅读全文

最近对鬼魂有了兴趣

最近对鬼魂有了兴趣,先转个帖子:http://www.qihoo.com/q/misc/8996437.html

自古以来,大宗教家、大哲学家等无不坚信灵魂的存在和不灭。

例如犹太族的摩西、耶稣,阿拉伯的穆罕默德,印度的释迦牟尼,以及我国的老子和孔子等,都亲证灵魂(神识)不灭,轮回确有。

阅读全文

如何选出所有子类

–测试数据

CREATE   TABLE   tb(ID   char(3),PID   char(3),Name   nvarchar(10))
  
INSERT   tb   SELECT   ‘001’,NULL   ,’山东省’
  
UNION   ALL   SELECT   ‘002’,’001′,’烟台市’
  
UNION   ALL   SELECT   ‘004’,’002′,’招远市’
  
UNION   ALL   SELECT   ‘003’,’001′,’青岛市’
  
UNION   ALL   SELECT   ‘005’,NULL   ,’四会市’
  
UNION   ALL   SELECT   ‘006’,’005′,’清远市’
  
UNION   ALL   SELECT   ‘007’,’006′,’小分市’
  
GO

–查询指定节点及其所有子节点的函数

CREATE   FUNCTION   f_Cid(@ID   char(3))
  
RETURNS   @t_Level   TABLE(ID   char(3),Level   int)
  
AS
  
BEGIN
  
DECLARE   @Level   int
  
SET   @Level=1
  
INSERT   @t_Level   SELECT   @ID,@Level
  
WHILE   @@ROWCOUNT>0
  
BEGIN
  
SET   @Level=@Level+1
  
INSERT   @t_Level   SELECT   a.ID,@Level
  
FROM   tb   a,@t_Level   b
  
WHERE   a.PID=b.ID
  
AND   b.Level=@Level-1
  
END
  
RETURN
  
END
  
GO

–调用函数查询002及其所有子节点

阅读全文