Community Member Profile
Kyle
Member since Jun 14, 2011
- Profile: /members/8484-Kyle.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Kyle
-
Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)
Posted on Jun 14, 2011 at 12:28 PM
What about the order of updates? Will this always be a valid statement? update u set u.UserName = t.UserName, u.updated = case when u.UserName <> t.UserName then 1 else 0 end from Users u join UserImport t on u.ID = t.ID... read more »
