Using SELECT statement to UPDATE records in SQL

Geeks With Blogs

17 Posts | 41 Comments

Software professional with 6 years of industry experience in software analysis, design and development.

ReadOnly TextBox value in AJAX Calendar Extender on postback ASP.NET

4 comments | 1766 views

ReadOnly TextBox value in AJAX Calendar Extender on postback ASP.NET

4 comments | 5 views

ReadOnly TextBox value in AJAX Calendar Extender on postback ASP.NET

4 comments | 2 views

ReadOnly TextBox value in AJAX Calendar Extender on postback ASP.NET

4 comments | 1 views

Announcements

Nouman Zakir while (true) { Post.NewArticle(); }

<< Using SELECT statement to INSERT records in SQL | Home | Technical Support Conversations >>

Using SELECT statement to UPDATE records in SQL

Comments (2) | Share

You can use SELECT statement to update records through UPDATE statement.
In the SET Clause use the SELECT statement along with desired filters to
update the records.

UPDATE tblDestination
SET tblDestination.col=value
WHERE EXISTS (
SELECT col2.value
FROM tblSource
WHERE tblSource.join_col=tblDestination.join_col
AND tblSource.constraint=value) Posted on Tuesday, August 4, 2009 6:28 AM SQL | Back to top

Comments on this post: Using SELECT statement to UPDATE records in SQL

# re: Using SELECT statement to UPDATE records in SQL

How would I insert it if the select part is a combination of fields from different tables?

Left by Rico on Nov 13, 2012 10:14 AM

# re: Using SELECT statement to UPDATE records in SQL

How would I insert it if the select statement is a combination of fields from different tables expressed as one value?
E.g. (select A.val1 * B.Val2 as MyTotal From A,B where blah blah blah)

Left by Rico on Nov 13, 2012 10:31 AM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Enter the code shown above

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure