sqlserver 增加参数视图，SQL Server 实现递归获取层级数据

一、标题的情况其实是不可以的。但可以用另一种方式解决 

 CREATE FUNCTION test(@ID_Department bigint)
 RETURNS TABLE
 AS
 RETURN
 (    select id,DepartmentName from SysDepartment where id=@ID_Department)
 GO

调用 ：

 select * from test(16508640061124406)

二、

with tmpTable
as
(
-- 1、根节点
select * from myTableName where Id = 16508640061124406
union all
-- 2、递归条件
select a.* from myTableName a inner join tmpTable b on a.parentId= b.id ) select * from tmpTable;