Q: How many ways does SQL Server start a transaction?
Answer: There are three kinds. The first is the explicitly distinguished transaction, which begins transaction the transaction with a begin flag. The second is the automatic submission of things
This is the default setting for SQL Server. Each T-SQL statement is automatically committed after the execution is completed. The third is implied transactions, in this way,
SQL Server automatically starts a new transaction after the current transaction is committed or rolled back, and the new transaction is not executed until the user commits a commit or rollback.
The system will start a new transaction. This creates a continuous chain of transactions.
Q: What is the difference between Cluster index and Noncluster index?
A: The structure of Cluster Index and Noncluster index are all balanced trees. The main difference is that the leaf node of cluster index is the data PAGE
The leaf node of noncluster index is the pointer to the data page.
Q: Can I modify the name of the table in SQL server6.5,7.0?
A: 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.
Q: After modifying the machine name of the machine where SQL Server7.0 is located, SQL Server cannot be started, what should I do?
Answer: In this case, run the SQL Server7.0 Setup program. The setup program will reset SQL Server based on the new machine name.
Q: What do I do if I don't have a successful installation of SQL Server7.0?
A: If you do not have a successful installation of SQLServer7.0, there are several files that can help you determine which step was wrong. First in the Windows directory
The SQLstp.log file contains detailed information about the setup process. View this file to make sure that Setup was wrong in that step.
If the setup process is faulty in the configuration section, then view the error log under the Mssql7log directory and the Mssql7install directory
Cnfgsvr.out file. Sqlserver7.0setup runs an application called Cnfgsvr.exe to configure SQL Server. This program launches SQL Server,
Connect to SQL Server and run 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, a professional who supports SQL Server will assist
You to resolve the issue.
http://www.bkjia.com/PHPjc/631215.html www.bkjia.com true http://www.bkjia.com/PHPjc/631215.html techarticle Q: How many ways does SQL Server start a transaction? Answer: There are three kinds. The first is the explicitly distinguished transaction, which begins transaction the transaction with a begin flag. The second type is auto-commit ...
