Experience of different SQL Server versions

1. for SQL Server 2005 Express, the query statement is similar to select * from table; for SQL Server 2005 development, the query statement is similar to select * from database... table;

2. When connecting to the database in Express, add \ sqlexpress to the host name. Do not add \ sqlexpress to development.

3. You must configure the corresponding attributes in the Configuration Manager for different versions.

4. The administrator must run msserver management studio to restart development. Otherwise, an error will be reported if you do not have the permission to restart the server.