Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Is this syntax guaranteed to continue working? Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 12:20 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 1:28 AM
Points: 2,105, Visits: 5,393
SwePeso (7/20/2013)
Why not use the OUTPUT clause?


Output clause works can output the data to the screen or to a table. It can't output the data into a variable. Since in this case I will always get only 1 column and only 1 record, I don't want to use temporary tables.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1476197
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse