0

Scenario: user-defined function returns one table.

If that table contains at least one row, one column in the table variable from another stored procedure should get updated.

Should I use cross join on UDF to update table variable?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Snehal Sawant
  • 1
  • Using T-Sql queries ,microsoft sql server – Snehal Sawant Oct 22 '19 at 13:43
  • 6
    TVPs must be declared `READONLY` and cannot be updated. You can of course update local table variables before passing them as parameters. From your question it's not clear what, if anything, you're having trouble with. – Jeroen Mostert Oct 22 '19 at 13:48

0 Answers0