SQL Server 2012 Results Grid

Question

Is it possible to perform basic calculations on a results grid, such as column totals?

This would make it much easier to compare results when editing queries.

Answer 1

I'm assuming by results grid, you mean what you get when you do a select query such as 'SELECT * FROM TABLE' in SQL management studio. If this is the case, then no, you can't.

Best thing you can do is, use one of the aggregate functions on the column(s) you want to do the calculation on such as 'SELECT SUM(ColumnName) FROM TABLE' will give you the sum of the values in that column.

List of SQL aggregate functions: https://technet.microsoft.com/en-us/library/ms173454(v=sql.110).aspx