Geeks With Blogs
Fórmulas e Cenas Object Reference Not Set to an Instance of an Object
update n
set
    n.fieldToUpdate=o.fieldToUpdateFrom
from
   originaltable o 
   inner join toTable n on n.id= o.id
 
Posted on Friday, July 9, 2010 8:00 AM Geral , Database | Back to top


Comments on this post: How to: Update a table from a select

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Sglima | Powered by: GeeksWithBlogs.net