文章分类 -  sql

that's all about sql,for explame,sqlserver,access,mysql
sqlserver2000 递归实现
摘要：create FUNCTION f_Cid(@ID bigint)RETURNS @t_Level TABLE(ID bigint,Level int)ASBEGINDECLARE @Level intSET @Level=1INSERT @t_Level SELECT @ID,@LevelWHILE @@ROWCOUNT>0BEGIN SET @Level=@Level+1 INSERT ... 阅读全文
posted @ 2009-10-27 19:55 火精灵 阅读(179) 评论(0) 推荐(0)