SQL Server

For details about the configuration of the COM + environment, see the excerptArticleDistributed transactions (1) --- MTS settings Http://blog.csdn.net/honkerhero/archive/2007/03/28/1544072.aspx For troubleshooting of running problems, see file

From different perspectives, we can divide the SQL server data platform into multiple components. The SQL Server Data Platform is divided into the following according to the common division principles of SQL Server internal team: SSAs: SQL

This method is applicable to SQL Server 2000 + Windows XP 1. exclude human factors: Confirm the connection information: Make sure the following fields are correct for connecting to the database: M_strsponse = "127.0.0.1"; // database

I. Problem description: 1. In SQL Server, the ntext/text/image field cannot be replaced by the replace function; 2. By convert field conversion, you can convert the ntext field to varchar (8000) and replace it with the relpace function. However,

When installing sqlserver, the system prompts "a previousProgramInstall a file that has been suspended on the installation computer. You must restart the computer before running the installer .", Sometimes there is no way to install it after

Some time ago, we found that there were a lot more trace log files in the database directory. TRC, each of which was 200 MB in size and filled up the server space ,,, The C2 audit mode of ms SQL Server. below is the abstract of Ms technet. You can

1 string Function1.1 length and AnalysisDatalength (char_expr) returns the number of characters in the string, but does not contain spacesSubstring (expression, start, length ).Right (char_expr, int_expr) returns int_expr characters to the right of

Synchronously update existing resources using the Data Processing TechniquesConcept of zookeeperCopying a group of resources from one source to multiple sources, it is an effective way to send a copy of data to multiple storage sites. Using NLP

/* Function for separating strings under DNT */ Create Function [dnt_split](@ Splitstring nvarchar (4000 ),@ Separator char (1) = ',')Returns @ splitstringstable table([Item] nvarchar (200))AsBeginDeclare @ currentindex intDeclare @ nextindex

Establishing a pool connection can significantly improve application performance and scalability. The SQL Server. NET Framework data provider automatically provides a connection pool for the ADO. Net client application. You can also provide several

1. Get all database names:Select name from Master .. sysdatabases order by name2. Get all table names:Select name from databasename .. sysobjects where xtype = 'U' order by nameXtype = 'U': indicates all user tables;Xtype = 's': indicates all system

The following describes how to use SQL statements to create databases, tables, stored procedures, views, indexes, rules, modify tables, and view data. The following controls are added: Imports system. DataImports system. Data. sqlclient Public class

1. Three backup modes Full backup, differential backup, and log backup 2. database recovery model Full recovery, large-scale Log Recovery, simple mode Switch Recovery Model: Right-click the database name, select Properties, select options, and click

  I. Introduction to sorting rules: What is a sorting rule? "In Microsoft SQL Server,The physical storage of strings is controlled by sorting rules. Sorting rules specify the bit mode and storage of each characterRules Used for saving and comparing

The following content is required to understand the table in SQL Server. As for the knowledge points, I will detail them one by one in future articles!Table 1. Create Table:Create Table DBO. Customer (cust_id int, cust_name char (12), cust_phone

1.4 Automatic File growth and automatic contraction SQL Server allows you to set the initial value and maximum value of a database, which can automatically increase or contract. These settings can prevent application modification failures caused by

SQL Server triggers (10) I. Most T-SQL statements can be used in statement triggers that cannot be used in triggers, but the following statements cannot be used in triggers.   Create statement, such as create database, create table, and create

Paging query using SQL statements in SQL ServerCreate a table: Create Table [testtable] ([ID] [int] identity (1, 1) not null,[Firstname] [nvarchar] (100) Collate chinese_prc_ci_as null,[Lastname] [nvarchar] (100) Collate chinese_prc_ci_as

A transaction is a mechanism and an operation sequence. It contains a group of database operation commands. All the commands will be used as a whole, and they will be submitted or revoked together to the system. The requests will either be executed

Document title: Data Conversion Between SQL Server and access and Excel by Li honggen Key words: SQL Server, access, Excel, Data Conversion In this paper, the conversion from C ++ builder research-http://www.ccrun.com/article/go.asp? I = 638 & D =