The syntax should be like
Create Function
Returns
(
Table Definition here
..
..
)
as
BEGIN
..
..
RETURN -- note no value is returned here
END
Its all about structured query language (SQL) - SQL Query Snippets, LINQ Snippets, SQL Stored Procedures, SQL Server Articles, SQL Server Feeds, SQL Server Analytics, SQL Server Integration Services (SSIS), Microsoft SQL Server BIG DATA - HortonWorks, SQL Server CRM Integration
Pages
▼
Tuesday, May 31, 2011
A RETURN statement with a return value cannot be used in this context. - Create Function
If this error occurs in the Create Function that uses a table then the variable after return statement should be removed
The syntax should be like
Create Function
Returns Table
(
Table Definition here
..
..
)
as
BEGIN
..
..
RETURN -- note no value is returned here
END
The syntax should be like
Create Function
Returns
(
Table Definition here
..
..
)
as
BEGIN
..
..
RETURN -- note no value is returned here
END
How to get the list of Functions in Database
How to Filter Functions from Sys.Objects
The following query will list of the Functions that are part of the database:
SELECT * FROM
sys.objects
where type in ('FN', 'IF', 'TF')
The following query will list of the Functions that are part of the database:
SELECT * FROM
sys.objects
where type in ('FN', 'IF', 'TF')