Update and Set in one statement? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Update and Set in one statement?

Message

From

30/11/2014 05:06:08

Kevin Goff
Pennsylvania, United States

To

29/11/2014 21:08:45

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Update and Set in one statement?

Environment versions

SQL Server:

SQL Server 2014

Application:

Web

Miscellaneous

Thread ID:

01611535

Message ID:

01611566

Views:

35

>
>>Why putting both the UPDATE and SET in the same expression is not a good suggestion?
>
>Because this is not documented as far as I know and you don't want to use undocumented features.

Naomi, this approach is documented and has been used by DBAs for years (among other reasons) as a way to simulate a factory sequence object.

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Click here to load this message in the networking platform