Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem duplicating/updating table records
Johnwm, Thank you, your example code worked just fine! I am new to SQL, so I knew that it could be done with an update statement, and there it is! I have definitely learned my lesson this time, I will make a duplicate database and test my custom scripts on there first! Thanks again. -
Problem duplicating/updating table records
Hello, I have the following problem: 1. I have a MS SQL 2000 database with a table of user accounts called tbl_User. 2. A faulty script was run on the data in the table and, it deleted each user's first and last name. 3. I was able to reconstruct the data and have created another table called...
