Adriaan : 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...
Adriaan: When I update a row, The PK itself is not changed. Is that the problem?
Sorry. 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.
