Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

update columns from another Database Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 2:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:12 AM
Points: 202, Visits: 635
Hi Team,

Am having two databases in one instance, Names are

SCC
SCCL


both are in sync, regularly we are using SCC for regular use,

i've one table called SEMP in SCC database with columns id, lname, fname, password
unfortunately data removed from column password,

now i want to get the data from SCCL database > SEMP table and update in SEMP table in SCC database.

Any query please.
Post #1423933
Posted Tuesday, February 26, 2013 2:25 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
UPDATE a
SET a.password = b.password
FROM SCC..SEMP as a
INNER JOIN SCCL..SEMP as b
on a.ID = b.ID
AND a.fname = b.fname
AND a.lname = b.lname



---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1423936
Posted Tuesday, February 26, 2013 2:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:12 AM
Points: 202, Visits: 635
Thank U Abu.
Post #1423942
Posted Tuesday, February 26, 2013 2:38 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
You welcome.

---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1423943
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse