Prefer tabs but your teammates use spaces? That's not a problem with the brand new formatting options in SQL Prompt. It's now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here's how it works, and how to get set up.
2017-06-06
4,008 reads
Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.
2017-05-02
5,605 reads
The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.
2016-11-29
6,105 reads
A quick tip for using a combination of block and line comments to test CTEs
2014-11-10
7,479 reads
We use a tally table to find the appropriate denominator for a given decimal part of a number.
2014-04-29 (first published: 2014-04-07)
1,211 reads
Another in the series of articles to help you "fill in the cracks" in your T-SQL knowledge. MVP Jeff Moden shows us a super simple, high performance method to solve this timeless problem.
2013-07-19 (first published: 2011-01-20)
27,119 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
Comments posted to this topic are about the item The Hidden Security Risks of...
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers