#sql server 2019 new features

[sqlxpertise-blog]

SQL Server 2019 – String Truncation Error Demystified...

SQL Server 2019 – String Truncation Error Demystified…

Before SQL Server 2019, String Truncation error is big mystery in SQL Server, especially if you have multiple String fields used in your Stored Procedure, it will hard to find out which field its failing and which value is causing the issue

See, Sample screenshot of String truncation error from SQL Server 2017 or before

In SQL Server 2019 CTP, If you enable DBCC TRACE FLAG 460, the String…

View On WordPress