摘要：1.with treeText(t_name,id,parent_id)as( select t_name,id,parent_id from tree where t_name='A' union all select t.t_name,t.id,t.parent_id from tree t,treeText tr where t.parent_id=tr.id)select * from treeText order by parent_id2.with treeText(t_name,id,parent_id)as( select t_name,id,parent_id 阅读全文

摘要：USE [Demo]GO/****** Object: StoredProcedure [dbo].[p_couser_Student] Script Date: 02/24/2014 20:43:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--Student insert trigger update Class C_COUNT--create trigger tr_I_Student--on Student--for insert--as--begin-- update Class set C_Count=C_Cou... 阅读全文

摘要：USE [Demo]GO/****** Object: StoredProcedure [dbo].[sp_Page] Script Date: 02/19/2014 21:26:34 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--declare @TotalCount int--exec Page 8,0,'S_Name','desc','%周%','',@TotalCount output--select @TotalCountALTER proc [dbo].[s 阅读全文