Posted by David Portas on 05/11/07 09:01

On 11 May, 06:41, kdpo <kdpo1...@gmail.com> wrote:
> Could someone tell where I can find out if it's true that during
> UPDFATE SQL Serve deletes data from table, and then inserts new one.
>
> Thanks
>
> -A


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
--

• Next in forum: Reading SHOW_PLAN output
• Prev in forum: Re: Last Day Of Previous Month...with a twist
• Thread view: Re: How does UPDATE statement work?

[Reply to this message]