天道酬勤,学无止境

SQL Prompt

SQL Prompt tutorial: Old style connection syntax (ST001)

SQL Prompt is a practical SQL grammar prompt tool. SQL Prompt automatically searches based on the object name, grammar, and code fragments of the database, and provides users with appropriate code selections. Automatic script settings make the code simple and easy to read--especially useful when developers are not familiar with scripts. SQL Prompt is installed and ready to use, which can greatly improve coding efficiency. In addition, users can customize it as needed to make it work in the way expected. There is no advantage to using the old join syntax. If the SQL prompt identifies its use in

2021-03-27 01:29:20    分类:博客    SQL Prompt   sql

Why not create a column with ANSI_PADDING set to OFF?

SQL Prompt is a practical SQL grammar prompt tool. It automatically searches based on the object name, grammar, and code fragments of the database, and provides users with appropriate code choices. Automatic script settings make the code simple and easy to read--especially useful when developers are not familiar with scripts. This article describes not to create a column with ANSI_PADDING set to OFF. It's a bit strange to find connection settings that permanently change the way certain data types in the table are retrieved, but this happens if you use SET ANSI_PADDING OFF when creating a

2021-03-27 00:04:44    分类:博客    SQL Prompt   sql   语法提示

The dangers of using Float or Real data types

SQL Prompt automatically searches based on the object name, grammar, and code fragments of the database, and provides users with appropriate code selections. Automatic script settings make the code simple and easy to read--especially useful when developers are not familiar with scripts. SQL Prompt is installed and ready to use, which can greatly improve coding efficiency. This article describes the dangers of using Float or Real data types. The floating-point data type can hold very large numbers, but it lacks precision. They are convenient for certain types of scientific calculations, but are

2021-03-27 00:03:46    分类:博客    SQL Prompt   数据库   SQL Server