TSQL - Iteration (Cursor, Fetch, Next)

Card Puncher Data Processing

Support

Select statements included within a function cannot return data to a client

Msg 444, Level 16, State 2, Procedure myProcedure, Line 44
Select statements included within a function cannot return data to a client.

Does all

FETCH NEXT

statements have an

INTO

in your table function ?

  • Bad
FETCH NEXT FROM myCursor;
  • Good
FETCH NEXT FROM myCursor INTO @myVariable1, @myVariable2







Share this page:
Follow us:
Task Runner