yhef的专栏

类似ORACLE中的start with connect by prior语法。说明：T_SYS_ORG机构表，字段:ROW_ID/PAR_ROW_ID，PAR_ROW_ID表示父机构的ROW_ID--[b]自上往下[/b][code="sql"]WITH NODES AS ( SELECT * FROM DBO.T_SYS_ORG par WHER...

转自：http://bbs.youkuaiyun.com/topics/320023621[code="sql"]if OBJECTPROPERTY(object_id('tb'),'isusertable')0 drop table tbcreate table tb(ybh nvarchar(10),ebh nvarchar(10),beizhu nvarchar(1000))...