Redirection, path, transaction

From the above test, we can see that before a user updates data, SQL Server will apply a row-Level Lock to the data table. If another user wants to query the locked data at this time, this user will wait until the transaction is completed before continuing to execute. In addition to querying the locked data, you cannot query the entire table. However, when the query conditions are added, You can query the data in the table that is not locked. Use pubsselect title_id, pricefrom titles with (nolock) from this we can see that after the with (nolock) keyword is added, SQL Server will skip the lock data and get the expected results. However, dirty data may be read, so be cautious when using it. 1. browser ASP file request-> server execution-> response. redirect statement-> the server sends response. the address after redirect is sent to the client browser-> the browser request executes the new address 2. the browser ASP file request-> the server execution-> the server. transfer statement-> switch objects from the server to new files: 1. response. redirect can switch to any existing webpage. 2. server. Transfer can only switch to a webpage in the same directory or subdirectory. Data Confidentiality: 1. response. after redirect, The address will be changed to the page address after the jump. For example, the original www.baidu.com jump to www.sina.com, then the jump to the address bar changes, that is, the page to jump to www.sina.com 2, server. after transfer, the address remains unchanged, hiding the address of the new web page and the parameter values attached to the address. Data Confidentiality. The amount of data transferred (the parameters attached to the URL): that is to say, the jump Address Bar remains unchanged. For example, if you are www.baidu.com and you are redirected to www.sina.com, the address bar will still be www.baidu.com instead of www.sina.com 1 and response. redirect can transmit only 2 kb of data. 2. When the transmitted data exceeds 2 kb, you must use server. Transfer. Response. Redirect can be targeted anywhere, including the Internet. The server. Transfer can only be directed to this site. It is not the directory of your website but cannot be located on the Internet. Response. redirect is faster than server. transfer is slow, response. redirect returns the Server client to the server and then to the client and server. transfer is on the server. transfer can pass form data, while response. redirect is not allowed. herf = "shouey.html" shouey.html is the file herf = "Web/shouey.html" shouey.html is the file herf =" .. /shouey.html "shouey.html is the file herf =" http://www.cnblogs.com/shouey.html "shouey.html is the file under the two subdirectories of the local current directory