Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

SQL UPDATE FROM example (See related posts) 

UPDATE emailFormat 
SET format=2 
FROM emailFormat EF
INNER JOIN user U ON EF.userID = U.userID

I have seen people use temporay tables and loops to do this sort of thing in the past
to sql by purplefeet on Tue Dec 06 13:49:20 +0000 2005

You need to create an account or log in to post comments to this site.


Related Posts