SQL SERVER 2005 递归查询备忘
--SQL SERVER 2005 递归查询
use TestDB
set nocount on
if object_id('Dept','U') is not null
drop table Dept
go
create table Dept(ID int,ParentID int,Name varchar(20))
insert into Dept select 1,0,'AA'
in
原创
2014-12-07 23:43:33 ·
770 阅读 ·
0 评论