I just try to excute the below query .Its giving me
ERROR:
Msg 208, Level 16, State 3, Line 1
Invalid object name 'dbo.f_getPeopleTabRowCounts'.
SELECT *
FROM dbo.f_getPeopleTabRowCounts(7424,'YYYYYYYYYYYYY','abcd','Y');
Anyone can help me pls.
How do I test a Table-Valued Function in SQL Server Management Studio?
Thanks
Sitansu
Here is :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[f_getPeopleTabRowCounts] (@PeopleRSN INT, @TabMask VARCHAR(10), @UserId VARCHAR (128), @enableRLS VARCHAR (1))
RETURNS VARCHAR(2000)
AS
BEGIN
Your function isn't returning a Table, so cannot be a Table Valued function, and looks much like a Scalar Valued Function.
Technet - Table Valued Functions
To test a Scalar Valued Function you should use