Is it possible to modify data in a table variable passed as a PARAMETER to stored procedure in SQL Server 2008?

Choose one of the answers below:
  1. Yes
  2. No
  3. Not possible to pass a table variable as parameter to stored procedure
Answer:
  1. No.
Explanation:

Table variables are READONLY when passed as a parameter to Stored Procedure. These can be used but not modified.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)