SQL operation summary

1. Set noucount off when set noucount on ends at the beginning of the stored procedure (after nocount is set to on, it is only valid for the current link (unless set nocount off ), Invalid for other SQL sessions)2. Set xact_abort on. When set

Gehashcode and hash algorithm

Three Principles of gehashcode: 1. If two objects are equal (defined by operator =), they must generate the same hash code. Otherwise, the hash code cannot be used to search for objects in the container. 2. For any object A, A. gethashcode () must

Self-write cache class

Public class MyCache { /// /// Insert a cache /// /// cache key /// cache value /// whether to use absolute expiration time; true if yes; false if not /// If the cache exists, whether to overwrite the cache value /// absolute expiration

Implement parent div transparency and child div opacity

css outer DIV translucent inner div Opacity-Implementation of the pop-up layer effect [Example] close Here is the pop-up window content click me tested and compatible with Internet Explorer 3.6, Internet Explorer, Firefox, and

A lock Layer

/** * Create a covering layer * Id: the id of the covering layer. If it is null, an id is automatically generated. * CssObj: Specifies the style object of the covering layer. It can also be a class name. * Opacity: a decimal point between 0 and 1,

Notes for passing parameters in Ado. Net

Create proc p_test @ Total int = 1 output As Begin If (@ total = 1) Begin Return End Select * from test where uid = @ total End   SqlDataAdapter sda = new SqlDataAdapter ("p_test", conn ); Sda. SelectCommand. CommandType = CommandType.

Discovery of asynchronous JS in Firefox

effects of continuously Scrolling up/down images (compatible with Firefox and IE) wqsdfdsfsdf

Test whether the database server is available

The setting of Connect Timeout in the SQL connection string is invalid and can only be determined through Socket. The Code is as follows: /// /// Test whether the database server is available /// /// Server IP /// server port, usually 1433 ///

Full-text index Learning

Create table products ( Pid int primary key, [No] varchar (100) unique not null, Pname varchiar (100 ), Shijian timestamp ) Insert products select 1, 'pro1', 'zhang san' Insert products select 2, 'pro2', 'Li si' Insert products select 3, 'pro3',

The second parameter of WaitHandle. WaitOne

Using System; Using System. Threading; Using System. Runtime. Remoting. Contexts; Namespace ConsoleApplication4{[Synchronization]Public class MyCounter: ContextBoundObject{ Private int _ expectedCounterVal;Private int _ currentCounterVal;Private

My Exec Method

Function Exec (funcName, arr, byResult ){ If (byResult ){ If (typeof funcName = "string "){ If (window [funcName]) { // If false is returned or no return value is returned, the execution will continue once, knowing that true is returned. If (!

Use the ln command to create a link

Ln 1.txt 2.txt create a hard link of 1.txt in the front directory ln-s 1.txt 2.txt create a symbolic link of 1.txt in the front directory two hard links of ln 1.txt 2.txt dic two hard links of ln-s 1.txt 2.txt dic Two Symbolic Links Ln-s dic

SQL, returns a random number

Returns a random number of 10: Declare @ M int, @ N intSet @ N = 10Set @ M = 1000Declare @ t intDeclare @ I intSet @ I = 0While (@ I BeginSelect @ t = cast (rand () * (@ M-@ N + 1) + @ N) as int)If (@ t = 10)BeginSelect @ tEndSet @ I = @ I + 1End    

Two common SQL paging Algorithms

Today, I spent two hours writing two paging algorithms. -- Not in: This method is used to query the data in front of a table.Create procedure Page_proc(@ PageSize int, -- page number,@ PageIndex int, -- page number@ TableName varchar (50), -- table

CodeSmith4.1 generate a file based on the template on the console

The content of class. cst is as follows: Using System;Using System. Data;Using System. Configuration;Using System. Collections;Using System. Web;Using System. Web. Security;Using System. Web. UI;Using System. Web. UI. WebControls;Using System.

Asynchronous JS testing in IE

Test.html: test 1. js is as follows:For (var I = 0; I }For (var I = 0; I } For (var I = 0; I } Function Fuck (){Alert ("fuck ");}

About new_link parameters of mysql_connect

Assume that there are two databases test1 and test2 on 127.0.0.1. The test1 database contains the test1 table and test2 contains the test2 table.$ Servername = "127.0.0.1 "; $ Username = "root "; $ Password = "root "; $ Conn1 = mysql_connect ($

Some simple proftpd configurations

1. Enable root Login(1) Delete the root in/etc/ftpusers (2) Add the following configuration in proftpd. conf: RootLogin on 2. Configure Anonymous logon and configure protfpd. conf as follows: # Perform ftp upload and download after Anonymous logon.

Iis compilation error CS0016 in win7

CS0016: failed to write the output file "c: \ WINDOWS \ Microsoft. NET \ Framework \ v2.0.50727 \ Tempora" After searching on the internet, I did the following myself: (haha, it will succeed. Of course, I have to think about it myself! I believe

About innerText and innerHTML

InnerText and innerHTML are two non-DOM standard methods. Difference: (InnerText in the figure) In IE, both innerText and inner HTML methods can run normally. However, innerText in FF is unavailable, but there is an alternative method:

Total Pages: 64722 1 .... 55976 55977 55978 55979 55980 .... 64722 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.