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.
| Author |
Topic |
|
sqlcoder
Starting Member
2 Posts |
 Posted - 2008-07-07 : 15:08:50
|
| Hi everyone,I have a table populated with data, and I am trying to replace the data with new data. I am using the UPDATE statement and referencing the tabel and columns correctly, however, after the update, the table is filled with nulls - only those that have been referenced for update.I would be grateful if anyone could help with this problem.Many thanks,sqlcoder |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-07-07 : 15:15:31
|
| please post a piece of your sql statement. with sample of data |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-07 : 15:46:00
|
| Pl Post your UPDATE code here.. then we will be in a position to HELP.ManinderSQL server Architect / Admin (DEV&PROD) |
|
|
|
sqlcoder
Starting Member
2 Posts |
Posted - 2008-07-07 : 16:09:41
|
| Hi,Thanks for your posts. I haven't got the code on this computer unfortunately, so I'll have to post tomorrow. If anyone could suggest a possible reason for the problem, or a work around (i.e. some other statement/method for changing data in my table) I would be very grateful for any feedvack.Thanks,sqlcoder |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-08 : 04:33:09
|
| Have you given any outer join conditions in your update? that may be one of possibility of apperance of null values. |
|
|
|
|
|
|
UPDATE table leaves NULLs