Posted by Roy Harvey on 07/04/07 17:01

On Wed, 04 Jul 2007 08:55:49 -0700, Yas <yasar1@gmail.com> wrote:

>I would like that if the table had a rowOld with: (ColValue1,
>ColValue2,2007-07-04 00.00.00.000)
>If I use the above suggestion and insert a rowNew with same values
>(ColValue1, ColValue2, 2007-07-04 00.00.00.000)
>...It should overwrite rowOld with rowNew, not insert rowNew as a new
>row.
>...and only insert as a new rowNew2 when this row has a different date
>eg. 2007-07-05 00.00.00.000

You can write an INSERT for a new row, or an UPDATE for an existing
row, but you have to choose which it is to be. In your case you have
to find out if the row exists and then run INSERT or UPDATE depending
on what you find.

Microsoft is adding MERGE to the next release of SQL Server, which
would allow you to write one command to accomplish both functions, but
it is not available today.

Roy Harvey
Beacon Falls, CT

• Next in forum: Cannot connect to database using Enterprise Manager
• Prev in forum: Re: No mapping between account name and security ID
• Thread view: Re: MS SQL getDate() Function remove Time

[Reply to this message]