Use an SQL Server template to write standard SQL statements

If you frequently encounter the following problems, you should consider using the SQL Server template to write standard SQL statements:

1. SQL beginners.
2. Common DML or ddl SQL statements are often forgotten.
3. In the SQL developed and maintained by many people, everyone has their own SQL habits, and there is no unified specification.

In SQL Server Management studio, many commonly used off-the-shelf SQL standard templates have been provided.

SQL Server Management studio-> View (View)-> template Explorer (template browser ). For example:

 

Take the table creation template as an example. The generated template SQL is: