2010年10月11日
sql server Common Table Expressions(CTE) 实现递归查询
WITH CTEArea([ID],[Code],[Name],[level]) as (     SELECT [ID],[Code],[Name],1 as [level] FROM [WMS_Area] WHERE [ParentID] ='00000000-0000-0000-0000-000000000000' and [Name]='江苏省'     UNION ALL     SEL... Read More
posted @ 2010-10-11 15:20 liuwei0514 Views(158) Comments(0) Diggs(0) Edit