view sql server transaction log

The garden has a very good article about SQL Server transaction isolation, feeling a lot of the introduction from the concept, for those beginners, see the touch of understanding is profound, so no longer repeat, the emphasis is on the example demonstration above. The first explanation is what transaction isolation is

Tags: Clear right-click Extension start modify cause build expansion space developmentTransaction log files transaction log file is a file that is used to record database updates, with an extension of LDF.In SQL Server 7.0 and SQL

field values from the cursor to the variable While @ Fetch_status = 0 -- Process items in a loop Begin Update Ta Set Ty = Ty - @ Tbqty Where PID = @ PID Fetch Next From Cur_1 Into @ PID , @ Tbqty If @ Error > 0 -If an error occurs Begin Rollback Tran -- Transaction Restoration Close Cur_1 -- Close and release a cur

Server Role changes, role swaps, and monitoring server location When an online database is shut down (either planned maintenance or unplanned), you might be more comfortable if the database on the standby server is available for access. A well-designed log shipping system that delivers the database

second connection SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDPrint 'dirty read'Select * from table1If @ rowcount> 0BeginWaitfor delay '00: 00: 10'Print 'no-repetition read'Select * from table1End Result of the second connection Dirty read A B C A1 B1 C1 A2 B2 C A3 B3 C 'No repeated read' A B C A1 B1 C1 A2 B2 C2 A3 B3 C3

END GO BEGIN TRY SELECT GETDATE () SELECT 1/0--evergreen divide by zero example! END TRY BEGIN CATCH SELECT ' There is an error! ' + error_message () RETURN END CATCH; 2. The function table that obtains the error message:The following system functions are valid in the CATCH block. Can be used to get more error messages: function Description Error_number () Returns the error number of the e

Transaction and concurrency Before learning things and concurrency, we should first understand two concepts: 1. What are things? Transactions are the basic unit of work in SQL Server. It usually consists of several SQL commands for reading and updating databases, but these operations are not considered final until a co

, status 0, procedure TT1, 17th rowsThe insert statement conflicts with the check constraint "T1. This conflict occurs in the Database "test", table "DBO. Salary", column 'salary '.The statement has been terminated. (One row is affected) No output in the result 111 indicates that the stored procedure is not executed. Test environment: SQL Server 2005 Express This is another example: 1.

Sometimes we do notSQL ServerOr you do not have permission to connectSQL Server,However, we want to view the contents of the backup file. In this case, we can useSQLBak ReaderGadgets. When you cannot restore the database, you can use this tool to view the database version of the backup.BakFile Corruption can also be usedSQL Bak ReaderOpen. UseSQL bakreaderOp

SQL ServerMedium DatabaseTransaction ProcessingIs quite useful, given that many SQL beginners write Transaction ProcessingCodeVulnerabilities often exist. This article introduces three different methods to illustrate howStored ProcedureWrite the correct code in transaction processing. Hope to help you. When writing

Tags: blog http io strong SP on log CTIGet ready:CREATE TABLE Nums (X int);Purpose: Inserts only one row into the table.--------------------------------------------------------------------------------------------------------------- ----------------------　　BEGIN TRANSACTION Tran_a-it is best to define a name for the transaction.Insert into Nums (X) VALUES (9);　　　　Save Tr