Vipin Agarwal
Tips & tricks on .Net, SQL & Javascript
Site Sections
Home
Contact
Syndication
Login
Posts
33
Comments
186
Trackbacks
0
<< ThrowIfMaxHttpCollectionKeysExceeded error message when doing postback
|
Home
|
Page_BlockSubmit - reset it to False, if there is a scenario when page doesn't postback on validation error >>
Update Query in SQL with SELECT statement
UPDATE
Table
SET
Table
.
col1
=
other_table
.
col1
,
Table
.
col2
=
other_table
.
col2
FROM
Table
INNER
JOIN
other_table
ON
Table
.
id
=
other_table
.
id
Share This Post:
Short Url:
http://wblo.gs/cl0
posted on Tuesday, March 13, 2012 4:16 PM
Print
Comments
#
re: Update Query in SQL with SELECT statement
Ike
3/13/2012 9:55 PM
if on mssql, the following would also work
UPDATE
Table
SET
Table.col1 = other_table.col1,
Table.col2 = other_table.col2
FROM
other_table
where
Table.id = other_table.id
#
re: Update Query in SQL with SELECT statement
Vision Express
2/4/2013 11:47 AM
I don't see the word SELECT anywhere!
Post Comment
Title
*
Name
*
Email
Comment
*
Verification
Remember Me?
Archives
January 2016 (2)
November 2015 (1)
August 2015 (1)
June 2015 (2)
July 2014 (1)
March 2014 (1)
July 2013 (1)
June 2013 (1)
March 2013 (5)
February 2013 (3)
March 2012 (5)
June 2011 (5)
October 2010 (1)
September 2010 (1)
March 2010 (3)
Post Categories
General
Certifications
Windows 8
Copyright © 2005 Vipin
This work is licensed under a
Creative Commons License