Why table "Type" parameter in SQL Server 2008 is made READONLY -
this question has answer here:
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
Post a Comment