Featured Post

Consumer Electronics for the 21st Century

There can be no doubt that one of the defining characteristics of the 21st century is the seemingly insatiable thirst for more and more advanced technology. Consumers are willing to wait on long lines for endless hours for the privilege of spending hundreds of dollars on the latest iPad, iPhone or other...

Read More

Network Marketing

Work on the internet is an excellent choice for anyone who is looking to generate income, whether you want to earn a few hundreds, or thousands of dollars every month. But it is not only an option, but is a reality for thousands of people around the world, and you can be one of them if you propose it....

Read More

SQL Server

Posted by Wii-Wii | Posted in General | Posted on 05-08-2016

Tags:

0

In mine blog, the dotDicas () I in general write articles on development .NET. Another day came until me a desenvolvedor, reading friend of mine blog, with a SQL doubt. Answered the question of my friend, I decided to write an article, to help other desenvolvedores that can come to have the same doubt. However mine blog is focado in development .NET, then I decided to look another space to publish my tip. With certainty, at some moment the majority of the desenvolvedores, that uses SQL Server, already was come across with necessity to bring up to date a register in a table, based on the value of a register in another table. Read additional details here: Peter Asaro. The ones that had not yet had this necessity, still will pass for this. will have the same doubt that I had: How I make this? The reply it is very simple. Update with inner join is alone to make one, thus: UPDATE prices SET field = t1.campo FROM prices T1 INNER JOIN prices t2 ON t1.campo_chave = Very simple t2.campo_chave, not? If one join not to be enough, makes how many joins will be necessary..

Comments are closed.