sql server cheat sheet

Label:Forwarded from: http://www.cnblogs.com/rainman/archive/2012/03/13/2393975.html 1. Overview 2, the connection string of the wording 3. SqlConnection object 4. SqlCommand object 5. SqlDataReader Object 6. DataSet Object 7. Releasing Resources 1. OverviewADO provides a wealth of database operations that can be divided into three steps: First, connect the database with the SqlConnection object; Second, establish the SqlCommand object, which

data, the same query in different circumstances may produce the opposite result, how to apply well is mainly in our personal understanding and understanding, hope to see this article friends can deepen some understanding of the index and understanding , and get rid of the error of index and develop high performance application. I am not a DBA, just a common developer, the above are some of the actual work experience, experience, in view of my level is very limited, there is said wrong or unders

Original: SQL Server needs to monitor which countersGeneral countersCollects server performance information for operating system servers, including processor, disk, network, memoryProcessor Processor1.1% Processor time refers to the percentage that the processor uses to perform non-idle threads. This counter allows you to determine the current percentage of CPU u

Say in front I'm not a dedicated visual FoxPro programmer, and it's been more than 10 months since the last time I wrote a complete application with visual FoxPro. Three days do not practicing, three days do not say oral life, I so long time not to become a fool! A few days ago my friend asked me to posting Excel->sql server data conversion program, the warm and promised. It took two nights to jot it down,

Tags: Express abort current Show data sheet tar NEC ROC romThis article is used to collect system built-in functions that are frequently used in operations, and to continuously organize One, commonly used metadata function 1. View the database ID and name db_id (' db Name '),db_name(' db ID ') 2. View object ID and name, object schema, object definition object_id ( " schema_name. object_name , " object_type " ) object_name (object_id [ , data

Tags: intent lock hierarchy span advanced existing pad content create pictureLock: Popular speaking is to add lock. Locking is a mechanism that the Microsoft SQL Server database engine uses to synchronize access to the same block of data by multiple users at the same time.Definition: When there are transactional operations, the database engine requires different types of locks, such as related data rows, da

Server CountersThe Access Methods object in SQL Server provides a counter that monitors access to logical data in the database, and the Buffer Manager counter monitors physical access to the database on disk. Access Methods access Mode Access methods monitors the methods used to access data stored in the database to help determine whether you can improve query p

', ' physics ', 93) Insertintotbvalues (' John Doe ', ' language ', 74) Insertintotbvalues (' John Doe ', ' mathematics ', 84) Insertintotbvalues (' John Doe ', ' physics ', 94) Go Select*fromtb Go Name Course Score ---------- ---------- ----------- Zhang San language 74 Zhang San Mathematics 83 Zhang San Physics 93 John Doe Language 74 John Doe Mathematics 84 John Doe Physics 94 2. Using SQL Server 2000

than the number of rows of data The statements and data used in the example are used only as demos, the actual development application is more complex than the sample data, the same query in different circumstances may produce the opposite result, how to apply well is mainly in our personal understanding and understanding, hope to see this article friends can deepen some understanding of the index and understanding , and get rid of the error of index and develop high performance application.

of these tables, the changes are recorded in a data table that collects the GUIDs in the data table when the Merge Agent runs, indicating the rows that were modified at the publisher and at the Subscriber. For data that is modified only at the publisher or at the Subscriber, the corresponding action, such as Insert,update,delete, resolves the conflict in a user-specified manner if both parties have GUIDs, and the default publisher takes precedence. Let's choose the simplest release mode (snapsh

Sub test () 'defines the process name Dim I as integer, J as integer, sht as worksheet 'I, J is an integer variable, sht is an Excel worksheet object variable, pointing to a worksheet Dim cn as new ADODB. Connection 'defines the data link object and saves the Connection database information. Add ADO reference first. Dim RS as new ADODB. recordset 'defines the record set object and saves the data table Dim strcn as string, strsql as string 'string variable Strcn = "provider = sqloledb;