Multi-Statement Table-Valued Functions

----------Multi-Statement Table-Valued Functions
--select * from employee1
CREATE FUNCTION myProc (@ID Int)
RETURNS @EmployeeList Table
( ID Int
, Name nVarChar(50)
, Sal Money
)
AS
BEGIN
IF @ID IS NULL
BEGIN
INSERT INTO @EmployeeList (ID, Name, Sal)
SELECT ID, Name, Sal
FROM Emp5
END
ELSE
BEGIN
INSERT INTO @EmployeeList (ID, Name, Sal)
SELECT ID, Name, Sal
FROM Emp5
WHERE ID = @ID
END
return
END
GO

select * from myProc(10)
select * from emp5