CODE SNIPPETS

All the Code Snippets and Samples you need

.NET C# VB.Net

How to use a select in update statement using MSSQL

ByAdministrator

Feb 20, 2015 , , , , , , , , , , , , , , , , , ,

To use a select statement in a update statement using MSSQL you can use the snippet below.

Sample SQL

UPDATE TableOne
SET
    t1.ColumnOne = t2.ColumnOne,
    t1.ColumnTwo = t2.ColumnTwo
FROM
    TableOne AS t1
INNER JOIN
    TableTwo AS t2
ON
    TableOne.id = TableTwo.id

By Administrator

Related Post

.NET C# Devexpress VB.Net

How to export Gridview data to Excel using devexpress XtraGrid

Nov 28, 2015 Administrator
.NET C# VB.Net

How to catch specific MS-SQL SQLExceptions in C# and VB.NET

Nov 20, 2015 Administrator
.NET C# VB.Net

How to extract a password protected zip file using DotNetZip in C# and VB.NET

Nov 12, 2015 Administrator
4 thought on “How to use a select in update statement using MSSQL”

Leave a Reply