Thanks very much for your reply.Thanks very much for your help.
But I still have my question.The primary key for the table is a composite...
When I update by statement(sql literal) rather than prepared statement.It cost less than 0.001s.
It seems that the sqlserver query optimizer did the...
When I update a row, The PK itself is not changed. Is that the problem?
I have poseted the table scripts and stmt text.
A table has 200000 rows.When I update one row with primary key, it cost 0.2s. I checked the excute plan, and found something can not be understood....
Separate names with a comma.