How does UPDATE statement work?

Could someone tell where I can find out if it is true that during
UPDFATE SQL Serve deletes data from table, and then inserts new one.

Thanks

-A

No that statement is not correct.

No that statement is not correct. SQL Server will in many cases do an "update in place".

However, an update *might* be performed physically as a delete followed by an insert. For instance
when the row doesn't fit the old page, or if you are modifying the key that you are clustering over.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

How does UPDATE statement work?

Replied in microsoft.public.sqlserver.server
Please do not multi-post.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Thank you.-A

Thank you.

-A