Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 UPDATE SQL !HELP ME

Author  Topic 

haibec
Yak Posting Veteran

54 Posts

Posted - 2006-09-08 : 07:34:01
Hi all!

I have two table USER1 includes field : ID, Username,Password and Table USER2 includes filed : ID ,Username,Name . When user register . Data will save into 2 that table . One reason or other, two filed ID on the two table not same but Username on the 2 table same . I want UPDATE all ID on the User1 = ID on the User2 .Please help meeeeeeeeeeee

nr
SQLTeam MVY

12543 Posts

Posted - 2006-09-08 : 08:20:26
duplicate
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71689

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -