UPDATE ROWGUID

CREATE TABLE [dbo].[Costo] (
[TpCosto] [varchar] ( COLLATE Latin1_General_CI_AS NOT NULL ,
[CodSoc] [varchar] (2) COLLATE Latin1_General_CI_AS NOT NULL ,
[Desc] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Onere] [varchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[Cat] [varchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NULL
) ON [PRIMARY]

I have the same row (TpCosto, CodSoc, Desc, Onere, Cat) in two
database but rowguid in the two table is different.
 >> Stay informed about: UPDATE ROWGUID 

your problem is that it is possible that the same values can be
entered in both sides between syncs. to do this you will need to add a
location column to your pk.

Here is an example of how this will work - assuming TpCosto & CodSoc
are your pk columns.

CREATE TABLE [dbo].[Costo] (
[TpCosto] [varchar] ( COLLATE Latin1_General_CI_AS NOT
NULL ,
[CodSoc] [varchar] (2) COLLATE Latin1_General_CI_AS NOT NULL ,
[Location] [sysname] not null default @@servername,
[Desc] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Onere] [varchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[Cat] [varchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NULL,
constraint CostoPK primary key (TpCosto,CodSoc,Location)
) ON [PRIMARY]

On Jan 31, 9:05 am, damar3 <dam....DeleteThis@gmail.com> wrote:
> CREATE TABLE [dbo].[Costo] (
>         [TpCosto] [varchar] ( COLLATE Latin1_General_CI_AS NOT NULL ,
>         [CodSoc] [varchar] (2) COLLATE Latin1_General_CI_AS NOT NULL ,
>         [Desc] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
>         [Onere] [varchar] (2) COLLATE Latin1_General_CI_AS NULL ,
>         [Cat] [varchar] (2) COLLATE Latin1_General_CI_AS NULL ,
>         [rowguid]  uniqueidentifier ROWGUIDCOL  NULL
> ) ON [PRIMARY]
>
> I have the same row  (TpCosto, CodSoc, Desc, Onere, Cat) in two
> database but rowguid in the two table is different.
 >> Stay informed about: UPDATE ROWGUID 

It is not clear what you want. If you want to "align" the data you can do it
using updates instead of inserts when it is required.

--

Rubén Garrigós
Solid Quality Mentors

"damar3" <damar3.RemoveThis@gmail.com> wrote in message
news:625460ff-1a3a-4685-bba7-46ff2e6bedc2@l32g2000hse.googlegroups.com...
>I have two table with the same data but rowguid are different. I have
> a conflict with violation of primary key. How can I align rowguid
> without delete row (they are in foreign key with other table) ?
 >> Stay informed about: UPDATE ROWGUID