All geek questions in one place

Interpreting SQL Server syntax errors

If there is one thing that I hate in SQL Server, these are terribly useless error messages. My favorite is "The incorrect syntax is near ..." because it almost doesn’t suggest what is wrong.

Are there any tools to better understand what is wrong with the expression? Or does anyone have other useful hints for identifying such errors?

+3
source share
2 answers

Hm ... You can double-click the error message in SQL Management Studio and go to the position where the error occurred.

, 100% . , , , , , - , , .

+2

SQL 2005, SQL 2008 intellisense, , . , Visual Studio.

SQL 2008.

+1

Source: https://habr.com/ru/post/1707483/

More articles:


All Articles