Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


161: From time to time synchronize two databases
From time to time synchronize two databases - Timing of the data synchronization server - Examples: - Test environment, SQL Server2000, Remote Server Name: xz, user name: sa, no password, test database: test - Server table (Query Analyzer to con...

162: 015: Verify error solution summary
015: Verify error solution summary VNI-2015: authentication error solution summary WINDOWS2000 we ORACLE DATABASE successfully installed after the day-to-day use of the process will often call DDL, DML, DCL, when the command prompt will appear th...

163: Check table records the first N
Check table records the first N Introduced before taking a variety of N records database written ... Author: CCBZZP 1. ORACLE SELECT * FROM TABLE1 WHERE ROWNUM <= N 2. INFORMIX SELECT FIRST N * FROM TABLE1 3. DB2 SELECT * ROW_NUMBER () OV...

164: To achieve real-time database synchronization
To achieve real-time database synchronization - Real-time example of simultaneous two tables: - Test environment: SQL2000, remote host name: xz, user name: sa, password: No, the database name: test - Create test table, the master can not use iden...

165: LServer2000 to deal with the problem of half-Chinese characters
L Server2000 to deal with the problem of half-Chinese characters / * Written by enydraboy ,2003-07-17 * / / * Published in the CSDN * / / * Reprint please specify the source and retain the copyright information * / Csdn experts in the forum, ask...

166: SQL * PLUS how to insert the string contains &?
SQL * PLUS how to insert the string contains &? [Tip] How to insert a SQL * PLUS string contains &? Method of a SQL * PLUS used in this order: set define off Method 2 (recommended) See the following examples: SQL> truncate table dem...

167: Weighing _DDL compile PL / SQL objects
Weighing _DDL compile PL / SQL objects Weighing DBMS_DDL compiled with PL / SQL objects This article, we will see how to use the DBMS_DDL package ALTER_COMPILE process has been re-compiled object is stored in the database. ALTER_COMPILE process ...

168: IP address of the first three sentence paragraph Statistics
IP address of the first three sentence paragraph Statistics / * Written by Jaron ,2003-07-10 * / / * First published in the CSDN * / / * Reprint please specify the source and retain the copyright information * / Site Stats experts are doing, we ...

169: tory (11) - Tree Table Game
tory (11) - Tree Table Game Tree structure of storage and management, is a platform in the relational database programmers working on the problem sooner or later have to face. That much, how can solve that small is not small, not handled properly, ...

170: erver lock mechanism
erver lock mechanism SQL server locking mechanism SQL server will have all the activities of the lock. The smaller the unit lock, the more complicated to deal with greater capacity, but the greater the cost of the management of locks. How to find ...

171: Article sbaseSQLAnywhere8.0 state in the system on the icon?
sbase SQL Anywhere 8.0 on the system state of the icon be? In the application run-time, Sysbase SQL Anywhere 8.0 database after the system state will be on the icon, sometimes users will not accidentally close it, resulting in system errors. How to...

172: Database log
Database log Customers to use the database as often as a result of the log is too large enough hard disk space, or from the backup file is too large can not be sent through the mail. More than under free, reference SQLSERVER the help of documents,...

173: L data storage backup and recovery process
L data storage backup and recovery process Today, there is no idle matter, drawing on the writing database storage backup and recovery process (and we exchange) if exists ( select * from sysobjects where name = pr_backup_db and xtype = p ) beg...

174: Design skills to deal with
Design skills to deal with In the development of enterprise applications are often subject to a wide range of business processing, a good application design and maintenance will bring a lot of revenue, from a simple case to start. A book sale of t...

175: , 2 minutes to get data dictionary table to update the document
, 2 minutes to get data dictionary table to update the document Been in systems development, data dictionary table update Do you find that Development process in the system, your database changes constantly, initially distributed to each develope...

176: Memory management mechanism SERVER2000 (c)
SERVER 2000 memory management mechanism (c) SQL SERVER 2000 in depth of the memory management mechanism (c) http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_01262004.asp Memory region SQL Server can be divided...

177: Memory management mechanism SERVER2000 (b)
SERVER 2000 memory management mechanism (b) SQL SERVER 2000 in depth of the memory management mechanism (b) http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_01262004.asp Addresses can access the application of ...

178: Memory management mechanism SERVER2000 (a)
SERVER 2000 memory management mechanism (a) SQL SERVER 2000 in depth of the memory management mechanism http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_01262004.asp Ken Henderson Microsoft Corporation Note: ...

179: According to the use of conversion software StatTransfer7
According to the use of conversion software StatTransfer7 On a data conversion software StatTransfer7 Oh, inadvertently found that the software, search, introduced articles found little time to find this software to introduce to you the hope that ...

180: erver database maintenance
erver database maintenance The process of using the database, due to power outages or other reasons, it may lead to some minor errors in the database, such as slow access to certain tables in particular, can not meet the conditions of query data. ...


Page 9 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]