Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    1

    Question Unanswered: table type argument as OUTPUT in PROC

    how can i define table type argument as OUTPUT in PROC and don't READONLY?
    if it's not possible, is there another way to do same this?

    thanks!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    From the manual:
    Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine.
    What are you trying to achieve?
    George
    Home | Blog

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •