Free eBook: 50 Ways to Avoid, Find and Fix ASP.NET Performance Issues

• 50 tips from the ASP.NET and SQL Server communities for boosting performance in your ASP.NET app.

 Click here is download

8 JavaScript Interview Questions You Need to Know

8 JavaScript Interview Questions You Need to Know (via Dice News in Tech)

Hiring manager Kevin Kubasik at marketing and web development agency HZDG has an insight assessment when it comes to hiring coders steeped in JavaScript knowledge. Says Kubasik, HZDG’s development director: “[It’s] a language that almost every developer can use to accomplish little tasks, but…

Update data in one table with data from another table in MS SQL Server

How to update the data from different table

Here is Sql Server Update statement

Update DestinationTable
Set Field = SourceTable.Field  //if you have multiple field separated by comma
From DestinationTable
Inner Join SourceTable
On DestinationTable.CommonField = SourceTable.CommonField

Below live example of update of sql server

Destination Table 

ProudctID	Name	ProudctPrice
100	Glasses	$29.99
101	Lens	$99.99

Source Table 

ProudctID	Name	ProudctPrice
100	Glasses	$49.99
101	Lens	$199.99

Update DestinationTable
Set ProductPrice= SourceTable.ProductPrice //if you have multiple field separated by comma
From DestinationTable
Inner Join SourceTable
On DestinationTable.ProductID= SourceTable.ProductID

Result after the update

Destination Table 

ProudctID	Name	ProudctPrice
100	Glasses	$49.99
101	Lens	$199.99

How to fix Compilation Error

How to fix Compilation Error

Read the compilation error message it tell you have multiple DLL of same control.

so we have to remove one of them.

just go to of that folder and simple delete one of DLL that has old Date.

here is folder path on mine 

c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\176f9068\e46e6059\

it might different of yours. just follow the compilation error message path.