0
 Followers
3
 Likes

Allow @@Rowcount being returned on a advanced query

Database
New

When I try to make a massive update with an advanced query I cannot get the rowcount to know how many items were updated.


If I try the query below the platform will throw an 'Unkown Rowcount Parameter used'. when this is a valid SQL statement


UPDATE {Company} SET {Company}.[TaxNumber] = 1
SELECT @@Rowcount


I think that the advanced query should allow this sintax.

Created on 22 Dec 2018
Comments (1)

Changed the category to Database


views
111
Followers
0