Articles

SQLServerCentral Article

SQL Server 2022 Build List

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

You rated this post out of 5. Change rating

2024-01-11 (first published: )

2,209 reads

Blogs

Friday Flyway Tips–The Version Control Blade

By

The Flyway Desktop Version Control tab is gone and a new blade has appeared...

A New Word: Candling

By

candling – v. intr. the habit of taking stock of your life on the...

Read the latest Blogs

Forums

Play To Your Strengths

By Grant Fritchey

Comments posted to this topic are about the item Play To Your Strengths

FTS Catalogs Set to Case Sensitive True/False

By SteveOC

I understand what the setting means for Collation Sequences and the impact it has...

XML path running slow

By SQL_Surfer

This is the sub query being used in the join and it's timing out....

Visit the forum

Question of the Day

Rounding Numerics

I have this code on SQL Server 2019:

SET ARITHABORT ON;  
GO  
DECLARE @result DECIMAL(5, 2),  
   @value_1 DECIMAL(5, 4),   
   @value_2 DECIMAL(5, 4);  
SET @value_1 = 1.1234;  
SET @value_2 = 1.1234 ;  
SELECT @result = @value_1 + @value_2;  
SELECT @result;  
GO
What setting of NUMERIC_ROUNDABORT will return an error from this code?

See possible answers