13 Examples of Answers to SQL Server Application Questions (3)_PHP Tutorial

Q: How many ways can SQL Server start a transaction?
Answer: There are three types. The first is an explicitly declared transaction, which uses BEGIN TRANSACTION as the starting mark of the transaction. The second is to automatically submit the transaction, which is the default setting of SQL Server. Each T-SQL statement will be automatically submitted after execution is completed. The third type is an implicit transaction. In this way,
SQL Server will automatically start a new transaction after the current transaction is committed or rolled back. This new transaction will not be executed until the user executes COMMIT or ROLLBACK. At this time, the system
The system will start a new transaction. This forms a continuous chain of transactions.
Question: What is the difference between Cluster Index and Noncluster Index?
Answer: The structures of Cluster Index and Noncluster Index are both balanced trees. The main difference between them is that the leaf node of Cluster Index is DATA PAGE
and the leaf node of Noncluster Index is the pointer of the data in DATA PAGE.
Question: Can the name of Table be modified in SQL Server 6.5 and 7.0?
Answer: You can use SP_RENAME to modify the name of the Table.
For example:
use pubs
create table test( a char(10))
sp_rename test, newtest
This example changes the newly created Table named test to newtest.
Question: After modifying the machine name of the machine where SQL Server 7.0 is located, SQL Server cannot be started. How to deal with this situation?
Answer: In this case, you need to run the SQL Server7.0 Setup program. The Setup program will reset SQL Server based on the new machine name.
Question: What should I do if SQL Server 7.0 is not successfully installed?
Answer: If you did not successfully install SQL Server 7.0, there are several files that can help you determine which step went wrong. First, the
SQLstp.log file in the windows directory contains detailed information about the setup process. Check this file to determine where the Setup error occurred.
If an error occurs in the configuration part of the Setup process, check the error log in the MSSQL7Log directory and the
Cnfgsvr.out file in the MSSQL7Install directory. SQLServer7.0Setup runs an application called Cnfgsvr.exe to configure SQLServer. This program starts SQLServer,
connects to SQLServer and runs the initial installation script. Any errors that occur during this process will be written to the Cnfgsvr.out file.
If you are unable to determine the cause of the installation failure, save the above file and contact Microsoft Product Support. Professionals who support SQL Server will assist
you in solving the problem.