I practised to create a function as follows:

Create Function fnEmployeeByDepartment (@DepartmentID int)
Return Table
As
Return (Select * From Employee Where DepartmetnID = @DepartmentID)
Go

But I got following error:

=================
Server: Msg 156, Level 15, State 1, Procedure fnEmployeeByDepartment, Line 2
Incorrect syntax near the keyword 'Return'.
Server: Msg 178, Level 15, State 1, Procedure fnEmployeeByDepartment, Line 4
A RETURN statement with a return value cannot be used in this context.


Please h-e-l-p !!

__________________
cocolocopolo

Report this post to a moderator

the first RETURN is "RETURNS" with a "S". don't forget that. the rest of ur function is two thumbs-up. make that slight change and ur off like a rocket.

so ur functio would look like this:
---------------
CREATE FUNCTION fnEmployeeByDepartment (@DepartmentID int)
RETURNS Table
AS
RETURN (Select * From Employee Where DepartmetnID = @DepartmentID)
Go
----------

cheers.

__________________
Crime is Common, Logic is Rare.
TechExams.net moderator

Report this post to a moderator

Thanks 2lazybutsmart.

It seems I am too careless.

__________________
cocolocopolo

Report this post to a moderator