Posted At : July 16, 2008 12:05 PM | Posted By : Murloc Oracle
Related Categories: SQL

Because I always forget how to do it, and always have to look up the syntax... Here's how to update table A with values from table B.

UPDATE A
SET name = B.name
FROM B
WHERE A.id = B.id;

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 312 Views

Posted At : July 27, 2007 9:07 AM | Posted By : Murloc Oracle
Related Categories: SQL

I'm full of complaints lately. I spent a great deal of time writing a beautifully formatted, very human readable SQL query. Then I saved it as a view and SQL Server was kind enough to reformat it as a big block of text, horribly aligned, impossible to read. Die in a fire, Microsoft.

Comments (2) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 273 Views
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner