CALLING STOREDPROCEDURES IN CURSORS
0 Answers
CALLING STOREDPROCEDURES IN CURSORS
| Flag | PURGE
hi
I AM TRYING TO EXECUTE A STORED PROCEDURE WITHIN A FUNCTION
CREATE FUNCTION [dbo].[fn_Usp_STUDENTS](@STUD_Id int)
RETURNS TABLE
AS
BEGIN
EXECUTE usp_GetTopTwosTUDENTSchemES @STUD_Id
RETURN
END
I SEE ERROR MESSAGE
INCORRECT SYNTAX NEAR KEYWORD BEGIN
CREATE FUNCTION [dbo].[fn_Usp_STUDENTS](@STUD_Id int)
RETURNS TABLE
AS
bEGIN
EXECUTE usp_GetTopTwosTUDENTSchemES @STUD_Id
RETURN
END
Incorrect syntax near the keyword 'EXECUTE'.
WHEN USED EXEC INSTEAD OF EXECUTE . I RECEIVED AN ERROR STATING
Incorrect syntax near the keyword 'EXEC'
ANY SUGGESTIONS WILL BE GREATLY APPRECIATED
THANK YOU SO MUCH FOR READING MY ERROR SCENARIO.
REGARDS
Email me when people comment.
Email me when people comment.
Loading...
An error occurred in subscribing you.
Email me when people comment.
Email me when people comment.
Loading...
An error occurred in subscribing you.
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.