• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

rows affected

i ran an update on one row, but got 2 lines of results back.. what would the other be for?

(1 row(s) affected)

(1 row(s) affected)
0
anushahanna
Asked:
anushahanna
2 Solutions
 
gplanaCommented:
Probably the updated table has a trigger which makes another update, so there are in fact two updates. This is the reason why sql analizer returns two outputs: one for the original update, and one for the updated made inside the trigger.

Hope it helps.
0
 
rajeevnandanmishraCommented:
Hi,

While checking as per the comments of "gplana", Please also check if you have enabled "Cascade Updates".
If that is the case, still you can get such result.
0
 
anushahannaAuthor Commented:
thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now