Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditional update syntax
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01376414
Message ID:
01376418
Views:
11
>I think this should work. Please correct me if I am wrong
>
>
>UPDATE [MyTable]
>SET [Field1] = @Field1,
>        [Field2] = @Field2,
>        [Field3] = CASE WHEN [Field4] THEN [Field3] ELSE @Field3 END
>
>
Yes, it would.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform