SQL update query using joins sql server

- 
UPDATE A
SET foo = B.bar
FROM TableA A
JOIN TableB B
    ON A.col1 = B.colx
WHERE ...

Comments

Post a Comment

Popular posts from this blog

How to use DbFunctions.TruncateTime

-
var activeSchedulers = (from scheduler in DbContext.Scheduler                                                     where scheduler.isActive == "A"                                                     && DbFunctions.TruncateTime(scheduler.Date) == DbFunctions.TruncateTime(DateTime.Now)                                                     select scheduler).ToList();
Read more

Microsoft Access Connectivity from C#

-
<configuration>   <appSettings>     <add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BCI.accdb;" />     <add key="ClientSettingsProvider.ServiceUri" value="" />   </appSettings> </configuration> http://aksadur.blogspot.com/2013/01/microsoft-access-connectivity-from-c.html
Read more

Tool 'dotnet-ef' failed to install. dotnet core

-
Image
PROBLEM: My .NET SDKs latest version is 5.0.103 but when i try to install the tool dotnet-ef with version 5.0.103 then it shows an error error NU1100: Unable to resolve 'dotnet-ef (>= 0.0.0)' for 'net5.0'. error NU1100: Unable to resolve 'dotnet-ef (>= 0.0.0)' for 'net5.0/any'. The tool package could not be restored. Tool 'dotnet-ef' failed to install. This failure may have been caused by: * You are attempting to install a preview release and did not use the --version option to specify the version. * A package by this name was found, but it was not a .NET tool. * The required NuGet feed cannot be accessed, perhaps because of an Internet connection problem. * You mistyped the name of the tool. Solution  : Try this command dotnet nuget list source output was no nuget source found. Then i run this command dotnet nuget add source  https://api.nuget.org/v3/index.json  -n DefaultNuget after adding nuget source dotnet tool install --global dotnet-...
Read more