Question: Is it possible to modify data in a table variable passed as a PARAMETER to stored procedure in SQL Server 2008?
Explanation: Table variables are READONLY when passed as a parameter to Stored Procedure. These can be used but not modified.
Look for further details at http://msdn.microsoft.com/en-us/library/bb510489.aspx
Note: The Question is taken from SQLServercentral.com.