Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #54.9K
|
I have 2 table in a ms sql database prod_curs_test and rebuturi_test. I want to update some fields in prod_curs_test with data from rebuturi_test. I used this to do that: [code] update dbo.prod_curs_test set dbo.prod_curs_test.cant_rebuturi = (SELECT dbo.rebuturi_test.Cantitate FROM dbo.rebuturi_test CROSS JOIN dbo.prod_curs_test WHERE dbo.rebuturi_test.Comanda = dbo.prod_curs_test.Comanda) where exists (SELECT … 
|
|
|
I got some experience working and managing ms sql databases, but now I am in a need to replicate 2 databases and I can't make it work. Please advise. If it's possible step by step. Thanx |