CREATE FUNCTION fn_CalculateListing(@Listing ListingColumn READONLY) RETURNS TABLE AS BEGIN DECLARE @result TABLE (ID INT, Name VARCHAR(50)) INSERT INTO @result(ID,Name) SELECT ROWID, Name FROM @Listing RETURN @Listing END
Msg 137, Level 15, State 2, Procedure fn_CalculateListing, Line 16 Must declare the scalar variable "@Listring". Msg 102, Level 15, State 31, Procedure fn_CalculateListing, Line 29 Incorrect syntax near 'BEGIN'.`
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)