Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


301: 4 full access to SQL syntax
Full access to SQL Syntax 4 HAVING clause condition Designate a specific group records, and to meet the conditions specified in HAVING or status, but on condition that the conditions set for the division. SELECT fieldlist FROM table WHERE selec...

302: 5 full access to SQL syntax
5 full access to SQL syntax BETWEEN ... AND operator Whether or not a particular numerical range of a particular person within the scope of this operator can only be used in the SQL statement. expr [Not] BETWEEN value1 AND value2 expr Calculate...

303: DebianSarge install Oracle10g
Debian Sarge install Oracle 10g Introduce my Debian Sarge install the Oracle 10g process. First of all, let me talk about my love machine configurations: AMD Duron 1.1G RAM 512MB (Hy sdram 256 * 2) Maxtor Diomand Plus 80G +40 G Official certif...

304: UnixODBC configure Linux to connect Oracle database
Linux on the Unix ODBC connection configured Oracle database Oracle10g ago, Oracle does not provide the UNIX / Linux under the ODBC driver, the most widely used is the unixODBC, unixODBC configuration is not complex, but if things go well if we do ...

305: Oracle9i database using the Notes
Oracle9i database using the Notes Oracle database version 9.2.0.1.0 of the Oracle HTTP Server has the following changes: I. Apache Jserv regard to the process of Oracle HTTP Server supports Apache Jserv the maximum number of processes have been r...

306: Clean up a lot of SQL log file
Clean up a lot of SQL log file - Compress the size of the log and database files / *-- Please pay special attention to the steps, no steps in front, please do not do the steps behind, otherwise you may damage the database. Generally do not recomm...

307: SQLSERVER with ACCESS, EXCEL data conversion
SQL SERVER and ACCESS, EXCEL data conversion Familiar with the SQL SERVER 2000 database administrator knows, the DTS can import and export data, in fact, we can also use the Transact-SQL statements to import and export operations. In Transact-SQL s...

308: SQLServer Index Optimization Tips
SQL Server Optimization Tips Index There are a number of SQL Server allows you to detect, adjust and optimize the performance of SQL Server tools. In this article, I will explain how to use SQL Server database tools to optimize the use of the index...

309: SQLServer2000 configuration options
SQL Server 2000 configuration options SQL Server server configuration options are fewer people understand that and often misuse the option. When a technical support personnel ask you to adjustment in accordance with an option in some way, and the o...

310: SQLServer Distributed Query: OLEDB connection (c)
SQL Server Distributed Query: OLE DB connection (c) For remote query execution attributes of the provider If the provider supports SQL functions not included in the report DBPROP_SQLSUPPORT syntax level, we can provide through the use of a variety...

311: SQLServer Distributed Query: OLEDB connection (b)
SQL Server Distributed Query: OLE DB connection (b) Distributed query processing in data types OLE DB Provider in accordance with the definition by the OLE DB data types (by the OLE DB the DBTYPE instructions) showed that their data. SQL Server on...

312: SQLServer Distributed Query: OLEDB connection (a)
SQL Server Distributed Query: OLE DB connection (a) Overview and terminology In MicrosoftSQL Server 2000 in SQL Server distributed query to allow users to access SQL Server-based server other than the data (in other servers running SQL Server or O...

313: SQLServer Performance Optimization
SQL Server Performance Optimization I. Overview In database applications, speed is an eternal topic. There are many factors that will affect the performance of the database, such as: operating systems, hardware factors, such as memory and disk spa...

314: Use the cursor (Cursors) will be the result of progressive multi-line query processing
Use the cursor (Cursors) will be the result of progressive multi-line query processing In the SYBASE database, a descriptive database language (SQL) is the most important of the most successful, most widely used database of language, its relational...

315: How can MySQL and OpenOffice Dances
How can MySQL and OpenOffice Dances A year ago, I became a Linux user, but for many years using Windows, so I think the use of Linux and some tools were not very accustomed to. Take the database example, in Windows, the development of a number of d...

316: jboss3.0 + tomcat4.06 configure mysql database Raiders
jboss3.0 + tomcat4.06 configure mysql database Raiders 1. To change the port Tomcat startup: Modify JBoss installation directory serverdefaultdeploytomcat4-service.xml file. Find Connector className = "org.apache.catalina.connector.http.HttpCo...

317: mysql backup and local backup script mutual double
mysql backup and local backup script mutual double Necessary to modify the configuration script, and then to root user. 1. The first time the implementation of remote backup first parameter first. 2. Local backup with local parameters 3. Remote b...

318: Perl installation and SYBASEASEFORLINUX connect SYBASE
SYBASE ASE FOR LINUX installation and perl to connect SYBASE Sybase ASE installation sybase-common-11.9.2-1.i386.rpm sybase-ase-11.9.2-1.i386.rpm Sybase OpenClient installation sybase-openclient-11.1.1-1.i386.rpm Methods: rpm-hiv sybase-commo...

319: Comparison of common database systems-SYBASE and SQLSERVER
Comparison of common database systems - SYBASE and SQL SERVER The reason why these two databases is for the purchase of MS SQL Server is a Sybase company launched in 1987 the Sybase SQL Server, also known as the University of INGRES version of the ...

320: Flashback database log SYBASE
Flashback database log SYBASE SYBASE, Inc. is the world's leading manufacturers of databases, the relational database products SYBASE SQL Server large and medium-sized enterprises in China have a large number of users. The author used in the co...


Page 16 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]