Can’t create stored procedure with table output parameter

by

Table parameters are readonly. You cannot select into them. Use Table-Valued Parameters:

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.

And Table-Valued Parameters:

You cannot return data in a table-valued parameter. Table-valued parameters are input-only; the OUTPUT keyword is not supported.

Read Arrays and Lists in SQL Server for a comprehensive discussion on alternatives.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Sql to select the rows and ignore the duplicate userid in SQL Server [closed]
  3. Identity increment is jumping in SQL Server database
  4. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  5. get a comma delimited string from rows [duplicate]
  6. T-SQL – Insert Data into Parent and Child Tables
  7. Identity column value suddenly jumps to 1001 in sql server [duplicate]
  8. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  9. Scope of temporary tables in SQL Server
  10. Sequence vs identity
  11. Count Number of Consecutive Occurrence of values in Table
  12. Get previous and next row from rows selected with (WHERE) conditions
  13. Convert Date format into DD/MMM/YYYY format in SQL Server
  14. Replace first occurrence of substring in a string in SQL
  15. Can SQL Server Express LocalDB be connected to remotely?
  16. How to correctly insert newline in nvarchar [duplicate]
  17. Find min and max for subsets of consecutive rows – gaps and islands
  18. Group All Related Records in Many to Many Relationship, SQL graph connected components
  19. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  20. How to subtract 30 days from the current date using SQL Server
  21. Cannot Resolve Collation Conflict
  22. Try_Convert for SQL Server 2008 R2
  23. How to get Previous Value for Null Values
  24. SQL Server: +(unary) operator on non-numeric Strings
  25. How to automatically generate unique id in SQL like UID12345678?
  26. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  27. How to get the first and last date of the current year?
  28. T-SQL – Aliasing using “=” versus “as” [closed]
  29. How to install localdb separately?
  30. How to escape square brackets inside square brackets for field name

Leave a Comment