SQL Server Home
Thank you for your feedback!
Column UPDATE permission required when updating only variable
- by Đonny
as Won't Fix
Due to several factors the product team decided to focus its efforts on other items.
A more detailed explanation for the resolution of this particular item may have been provided in the comments section.
11/9/2012 7:35:58 AM
When an UPDATE statement updates a variable it requires column update permissions.
ATTACH A FILE
EDIT THIS ITEM
Item can only be reassigned when it is active.
to post a comment.
Please enter a comment.
on 11/20/2012 at 6:00 AM
Construction of expression acceptable, function Column_Updated() returns the correct set of columns, but that seems illogical to check rights, as if all the columns are updated.
And what are the ways to change RowVersion, when no any other column can be changing (but updating referenced data, for example)?
on 11/19/2012 at 4:02 PM
Entity Framework generates this strange query. I had had no idea that this is a valid syntax before we changed some permissions, EF stopped working and I started investigating.
on 11/19/2012 at 2:55 PM
Would you first mind explaining why you are using the "set @p=0" within an UPDATE statement rather than just using it as it's own statement? Thanks.
to post a workaround.
Please enter a workaround.
Attach a file
© 2017 Microsoft