SQl query in 2012 gives error

Question

SELECT * FROM Product COMPUTE MAX(Qty) Error is : Msg 156 Level 15 State 1 Line 1 Incorrect syntax near the keyword 'COMPUTE'.

Nanhe Siddique · Answer

as per my knowledge compute feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work and modify applications that currently use this feature as soon as possible

Rajeesh Menoth · Answer

Hi I think your syntax is wrong.. Ref : https://technet.microsoft.com/en-us/library/ms181708(v=sql.105).aspx

Manish Kumar Choudhary · Answer

what is COMPUTE in this query ?

Upendra Pratap Shahi · Answer

I'm working with SQL2012

Upendra Pratap Shahi · Answer

SELECT * FROM Product COMPUTE MAX(Qty) compute max quntity