August 19, 2009 at 12:37 am
I get the following error when executing the code listed below. Any ideas what I'm doing wrong?
Server: Msg 16947, Level 10, State 1, Line 1093055397
No rows were updated or deleted.
The statement has been terminated.
(0 row(s) affected)
declare @d1 char(1)
declare cur1 cursor for
select col1 from tab1 where col2 = 1
open cur1
fetch next from cur1 into @d1
update tab1 set col1 = '1' where current of cur1
deallocate cur1
any help please
August 19, 2009 at 1:26 am
That message means you are trying to update a view that joins to at least one other table.
I assume in your code that "tab1" is actually a view.
What are you trying to achieve... from the code you've given, it doesn't look like you need to use a cursor anyway.
August 19, 2009 at 1:45 am
Just as an aside to that , on the few occasions that ive used 'where current of' ive found it to be pretty poorly performing.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy