table synchoronize

[aajaydee]

I have a two databases running on one server
I want to update table in current database from other database name sitemgr on same server
So data on both table will be synchoronize


Update
tblUser
set
UserName = p.UserName,
LoginID =p.LoginID,
EmailAddress =p.EmailAddress
From
sitemgr.dbo.tbluser p

what I got is
last record of sitemgr.dbo.tbluser is inserted into tbluser

which I do not need

would you please help
what I’m doing wrong

 

[SQLDenis]

Update
u
set
u.UserName = p.UserName,
u.LoginID =p.LoginID,
u.EmailAddress =p.EmailAddress
From
tblUser u join sitemgr.dbo.tbluser p on u.UserID =p.UserID (??)

what's the key to update?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[aajaydee]

thanks