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

Business Development Tips

Starting a business and a difficult step. Business may be different, maybe you want to create a production of a vaccine against swine flu, can you decide to make the production of nano-materials, or trade. Each species has its own business features. In every kind of business has its own rate of return,...

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.