Why table "Type" parameter in SQL Server 2008 is made READONLY -


i have searched did not found simple understandable answer. question is: why table "type" parameter in sql server 2008 made readonly while using in stored procedure?

i imagine avoid unintended side effects. if pass in table input parameter, not expect changed. same said of input parameter - if pass in @id of 12 , after run stored procedure @id set 14, cause lots of hard debug issues.

you can still make changes inputted table parameters need make separate output parameter changes explicit.


Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -