The multi-part identifier "sdb.dbo.getempbygender" could not be bound.

See more:

SQL

My table(emp):

Column Datatype Allownulls

Id int No

Name varchar(50) Yes

Dateofbirth date yes

Gender varchar(50) Yes

Deprtmentid varchar(50) Yes


My function:

USE [sdb]
GO
/****** Object:  UserDefinedFunction [dbo].[getempbygender]    Script Date: 09/02/2016 19:41:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create function [dbo].[getempbygender](@Gender varchar(50))
returns table
as
return( select Id,Name,Dateofbirth,Deprtmentid from emp where Gender=@Gender ).

whenever excute 'Command(s) completed successfully' msg will be given but while call the function error will thrown like as "Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "dbo.getempbygender" could not be bound."


call the function:

select [dbo].[getempbygender] 'Male'

pls help me.

Thank u

What I have tried:

whenever excute 'Command(s) completed successfully' msg will be given but while call the function error will thrown like as "Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "dbo.getempbygender" could not be bound."