Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Do This In SQL
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How To Do This In SQL
Miscellaneous
Thread ID:
01064287
Message ID:
01064287
Views:
53
I'm trying to work out this update

Is this the most efficient way to do this?
UPDATE media_order_detail
  SET accttype = '',
      e_type = commits.oldetype
   where id in
    (select id 
      from commits
      where statname = 'WFSB' and invoiceid = '86883-2_'
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform